3,815
When I log into our citrix server, the VBA code on a window runs. However, another user logs into the same citrix server and the code does NOT run. I have even changed the permissions on the dynamics.vba file to be full control for everyone. Why is this code not running for some users?
*This post is locked for comments
We are using GP 10, SP4.
We have had VBA code running and some modified windows with VBA code for 6 months now.
Term server for the users.
Everything had been fine for all this time.
Recently we imported a package file that had a very few modifications to the VBA logic. No other changes.
We have imported maybe a dozen packages with logic changes over the last 6 months, and all was fine.
But now, only the administrators see VBA.
All the normal users do not see any VBA.
Customizations Maintenance does not show "with VBA" after any of the windows for the normal users.
But it shows "with VBA" as it should for all the administrative users.
It sounds like fixing the registry permissions would resolve this issue, but it is puzzling after all this time, it now breaks.
Any suggestions what could have caused it to break?
It works fine on the TEST environment, which is a copy of PROD.
It is full control permission on 4 keys only (as per KB 929612):
https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;en-us;929612
• HKEY_CLASSES_ROOT\Clsid
•
HKEY_CLASSES_ROOT\Typelib•
HKEY_CLASSES_ROOT\Interface•
HKEY_LOCAL_MACHINE\Software\Classes\CLSIDIt solves the problem and most sites using VBA on Terminal Server/Citrix have made this change.
David Musgrave [MSFT]
Escalation Engineer - Microsoft Dynamics GP
Microsoft Dynamics Support - Asia Pacific
Microsoft Dynamics (formerly Microsoft Business Solutions)
http://www.microsoft.com/Dynamics
mailto:David.Musgrave@online.microsoft.com
http://blogs.msdn.com/DevelopingForDynamicsGP
Any views contained within are my personal views and not necessarily Microsoft policy.
This posting is provided "AS IS" with no warranties, and confers no rights.
I went another route. I added a trigger to the SY00500 table and set the Post To GL = true whenever an inventory batch is saved. Much easier than having to modify registry permissions on each server we have. I don't know any corporation that would give all users "Full Permission" on registries. That's just unheard of.
If this is caused by the registry permissions issue (which is common on Citrix/terminal server), then you will need to get the IT guys to make the registrry changes or, make everyone administrators, or stop using VBA.
I have had other sites complain about changing the registry, but that is what is required.
I cannot say what has changed, maybe these are new Citrix machines and the changes which were made previously have been lost.
David Musgrave [MSFT]
Escalation Engineer - Microsoft Dynamics GP
Microsoft Dynamics Support - Asia Pacific
Microsoft Dynamics (formerly Microsoft Business Solutions)
http://www.microsoft.com/Dynamics
mailto:David.Musgrave@online.microsoft.com
http://blogs.msdn.com/DevelopingForDynamicsGP
Any views contained within are my personal views and not necessarily Microsoft policy.
This posting is provided "AS IS" with no warranties, and confers no rights.
We have been running Dynamics 9 with this vba code on our citrix servers for 2 years and it's never been an issue until recently. I look at this TK and we have to change registry permissions? We can't do that in a corporate network. I tried method 2, but receive an error with the regtlib.exe not existing.
This sounds like the registry permissions issue discussed in the following Knowledge Base (KB) Article:
A user who is not an administrator experiences VBA permission problems in Microsoft Dynamics GP
https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;en-us;929612
David Musgrave [MSFT]
Escalation Engineer - Microsoft Dynamics GP
Microsoft Dynamics Support - Asia Pacific
Microsoft Dynamics (formerly Microsoft Business Solutions)
http://www.microsoft.com/Dynamics
mailto:David.Musgrave@online.microsoft.com
http://blogs.msdn.com/DevelopingForDynamicsGP
Any views contained within are my personal views and not necessarily Microsoft policy.
This posting is provided "AS IS" with no warranties, and confers no rights.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (