Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Can GP 2015 and GP 2010 properly co-exist on a WIndows 8 machine?

(0) ShareShare
ReportReport
Posted on by 8,515

After installing GP 2015 on my Windows 8 box, the GP 2010 client now produces VBA errors.

The error seems to be related to VBA no longer being able to set up an ADODB record set properly.

We reinstalled VBA components and MDAC 2.8 SP1.  We reinstalled GP 2010.  None of these worked.

I have searched for a solution and found none so far.

Thanks

TIm

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Can GP 2015 and GP 2010 properly co-exist on a WIndows 8 machine?

    Hi Tim,

    I wish I had seen your article before I installed GP 2015. I had installed it successfully on a SQL server sitting happily alongside GP2010, which had VBA modifications.

    When the GP 2015 client was installed onto the Terminal Server it broke GP2010.

    An uninstall of both versions of Dexterity components, followed by a  re-install of GP 2010 got the site working again.

    There must be some code that is broken with VBA from Office that causes the issue as it worked fine on the SQL server that did not have Office installed.

  • Tim Foster Profile Picture
    Tim Foster 8,515 on at
    RE: Can GP 2015 and GP 2010 properly co-exist on a WIndows 8 machine?

    Installing GP 2015 R2 allows GP 2010 to function correctly without error.

    Thanks

    Tim

  • Tim Foster Profile Picture
    Tim Foster 8,515 on at
    RE: Can GP 2015 and GP 2010 properly co-exist on a WIndows 8 machine?

    Confirmation received this morning from Microsoft that the March Hotfix corrects the VBA ADO connection problem in GP 2015.  However, installing GP 2015 will break a previous version's ability to create a connection with the UserInfoGet.CreateADOConnection method in VBA .

    They are working on it.

    Tim

  • Suggested answer
    RE: Can GP 2015 and GP 2010 properly co-exist on a WIndows 8 machine?

    Frank that is what I am doing as I am not prepared to take the chance of cross contamination.

    I have a box where I have a different VM for each version / OS combination for GP10 to GP2015

    Only spin them up if and when needed to test - otherwise keep them shut down - way to much overhead - but it seems to work.

  • Tim Foster Profile Picture
    Tim Foster 8,515 on at
    RE: Can GP 2015 and GP 2010 properly co-exist on a WIndows 8 machine?

    For those following this thread.  The March Hotfix is in and I have reopened the Support Incident (i.e. GP 2010 is still broken).

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,257 Super User 2025 Season 1 on at
    RE: Can GP 2015 and GP 2010 properly co-exist on a WIndows 8 machine?

    I would try setting up a VM on your Win8 box, load Win7 on the VM and load the 2010 client there.  Worth a shot.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Can GP 2015 and GP 2010 properly co-exist on a WIndows 8 machine?

    Regards, Mr. Tim Foster.

    In my case, if I was useful representation said, reiterating that had not yet seasoned with error for not having VBA solutions that incorporate business objects (mostly used for VS SDK Tools).

    I confirm that fomented a possible workaround in another similar topic as it was closed.

    Appreciate your collaboration.

    Goodbye cordially.

  • Verified answer
    Tim Foster Profile Picture
    Tim Foster 8,515 on at
    RE: Can GP 2015 and GP 2010 properly co-exist on a WIndows 8 machine?

    Confirmed by Microsoft Tech Support: Known Defect.

    No workarounds.

    Must wait for March Hotfix.

    Tim

  • RE: Can GP 2015 and GP 2010 properly co-exist on a WIndows 8 machine?

    Tim be sure to post what you get back from Microsoft - I have feeling you are not the only one with the situation or will not be the last at any rate.

    Take care.

  • Tim Foster Profile Picture
    Tim Foster 8,515 on at
    RE: Can GP 2015 and GP 2010 properly co-exist on a WIndows 8 machine?

    I don't think this will be particularly helpful, but here is what you asked for:

    If you are experiencing this problem, you should be seeing the same thing.

    This code is taken straight from the VBA developer's guide:

    Public Sub foo()

    Dim cn As New ADODB.Connection
    Dim rs As New ADODB.Recordset
    Dim CoName As String

    CoName = UserInfoGet.CompanyName

    Set cn = Nothing
    Set cn = UserInfoGet.CreateADOConnection

    End Sub

    The code errors on
    Set cn = UserInfoGet.CreateADOConnection

    I am opening a support issue.

    Tim

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,971 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,846 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans