22,782
I have an odd problem at the moment. In the last few weeks I have started to get the above error on my development box when modifying a form or report by adding in an ADO connection.
The error appears on the line:
Set mobjConn = UserInfoGet.CreateADOConnection
I can use UserInfoGet to get the IntercompanyID or other values; if I move the code to the client's system the VBA works without problem. It only errors on my development box.
*This post is locked for comments
Thank you so much for the quick response. We'll work on scheduling an upgrade for our client to see how it is working in their environment.
It is fixed in GP2015 R2, and also the latest tax update for GP2015.
Have you heard if this has been resolved with GP 2015 R2?
Cross-posting tammy's reply from partner support:
Hi All,
Thank you for the questions. This is a known issue with the DLLs installed as a part of the GP2015 Dexterity Shared Components. We are working to have this addressed in a tax release to be shipped later this month.
One thing to note is that once you install the GP2015 Dexterity Shared Components, you will get the error in both GP2013 and GP2015, if running/testing both on a single box. In order to get your GP2013 up and running again, uninstall the Dexterity Shared Components for BOTH GP2013 and GP2015; then reinstall the Dexterity Shared Components for GP2013 only.
Have you filed an incident with support yet?
Is there a defect number to reference?
Tim
Hi Kevin
The only workaround I've found so far is to use Windows authentication but it's not exactly a great solution. We need a fix from Microsoft really...
M.
Hi
It seems that a GP 2015 install breaks UserInfoGet.CreateADOConnection on ALL installed versions of GP. Must be one of the shared DLLs?
Matt
Thank you for the suggestion ... Unfortunately it isn't working in my situation.
I changed "Set cn = UserInfoGet.CreateADOConnection" to
"Set cn = VBADynamics.UserInfoGet.CreateADOConnection"
Same error.
I do have a reference to Microsoft Dynamics GP VBA 14.00 Type Library. However, GP 2010 is also on the machine and the reference Microsoft Dynamics GP VBA 11.00 Type Library is available but not marked.
I'm going to check with the client to see if GP 2010 can be uninstalled just in case there is a conflict.
I'm interested in any other advice you may have!
Lisa
Try using the fully qualified name VBADynamics.UserInfoGet.CreateADOConnection
and check the VBA project's references.
You need the 'Microsoft Dynamics GP VBA xx.00 Library' for your version of GP xx.00
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,401
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
