Migrating from Access 2010 to 2016 and Windows 10: RRS feed

  • Question

  • Migrating from Access 2010 to 2016 and Windows 10:

    • Under Windows 7 I opened the Access software with Access 2016 and saved it as accdb and accde, both versions worked fine
    • I copied both versions to Windows 10 and the accdb worked but the accde version couldn’t retrieve the date (=DateDiff("yyyy",[DateOfBirth],Date())).
    • I copied the accdb version to Windows 10 and created a new accde image but that also would not retrieve the date.
    • After spending a number of hours I discovered that Windows 10 linked to an earlier version of the references, see the Microsoft Office Access database engine Object Library.  Windows 10 is using version 15.0 and Windows 7 is using version 16.0

    Could the problem be caused buy the different libraries?

    Does Access load modules from the compiled version that are not in the source code?

    Are there different versions of VSOCX32?

    Could there be another cause of the problem?
    Monday, August 28, 2017 2:40 PM

All replies

  • Hi, Not sure I'm clear. You said Win7 has Access 2016, but you didn't say what version of Access is installed on the Win10 machine and your title says you're upgrading from 2010 to 2016. When you design in 2016, 2010 will have problems opening it.
    Monday, August 28, 2017 3:07 PM
  • You've already identified the issue, the references, so you need to update the accdb references on the Win10 machine.

    14 = Office 2010
    15 = Office 2013
    16 = Office 2016

    I want to understand your setup

    Old -> Win7 with Access 2016
    New -> Win10 with Access 2016

    Yet you are getting the reference issue?!  Where does Access 2010 come into the picture exactly? If Win10 is using version 15.0 that makes me believe it is running Access 2013, not 2016.  Do you have the full version of Access or the runtime?

    As an FYI, whenever you get error with basic functions (Date, Left, Right, Mid, ..) you can almost always guarantee it is a Reference issue.

    Daniel Pineault, 2010-2017 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    Monday, August 28, 2017 3:18 PM
  • Are you running 64-bit Access under Windows 10? Keep in mind that 64-bit apps cannot load 32-bit components, which may be the case with VSOCX32 or whatever other in-process components you may be using.

    Paul ~~~~ Microsoft MVP (Visual Basic)

    Tuesday, August 29, 2017 12:54 PM