Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Only "sa" Has Access to a VBA Customization

Posted on by Microsoft Employee

Hello:

In GP 2013 SP2, we created a VBA customization for an inquiry window.  There has been no modification of that window.

The effect of the VBA code only works, when "sa" is logged into GP.  It does not work, when other GP users are logged in.

I know that this is a broad question.  But, what are some reasons as to why "sa" would be able to "reap the rewards" of a VBA customization while other GP users would not?

Thanks!

John

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Only "sa" Has Access to a VBA Customization

    Hi Guys:

    I found out that the developers here had a window in place that is tied to a stored procedure.  Since my GP user ID is in that window, I simply cannot see my customization.

    It's a long story.  But, in the end, we found out that my VBA code works.  I apologize, for the confusion and thank you for your help!

    John

  • Verified answer
    David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,926 Most Valuable Professional on at
    RE: Only "sa" Has Access to a VBA Customization

    Are you using the same windows user?  There are situations were a non-administrator user does not have access to the registry keys that VBA needs.  This issue is most common on Terminal servers and has been documented in KB articles.

    support.microsoft.com/.../929612

  • Verified answer
    Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: Only "sa" Has Access to a VBA Customization

    Have you checked in the environment where you are trying to run the code if Customization Site Enabler is selected under the Registration window? You will need this to run VBA code.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans