BethanyW 10/4/2010 5:26:55 PM

Data Access 101 - getting a dataset using UserInfoGet

In Microsoft Dynamics GP 10.0, new connection objects were added to the VBA code. These new connection objects replace the RetrieveGlobals.dll and RetrieveGlobals9.dll files in Microsoft Dynamics GP. This new VBA code lets you create an active connection based off the username and password of the user who is currently logged into Microsoft Dynamics GP. This new connection object is named UserInfoGet. This UserInfoGet connection object enables you to use the following properties and methods:

  • The CompanyName property
  • The CreateADOConnection method  
  • The IntercompanyID property  
  • The UserDate property  
  • The UserID property  
  • The UserName property 

Code sample:


Version: Unknown or N/A
Section: VBA

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables