Old database references to MS Access Runtime? (1 Viewer)

[minimen456]

There is a *.mdb database written in old MS Access 2001. There are bunch of references. How do I move them to new computer where only MS Access 2016 Runtime is installed?
Do I need to just copy DLLs to a new computer in the same folder as before?

 

[arnelgp]

probably will not work, since old db are made in x32, while newer access runs on x64.

 

[isladogs]

These are the steps I would use
1. Convert it to an ACCDB file and open in A2016 (full version) or similar for testing
2. Many references should automatically be updated e.g DAO and ADO but other non-standard references may be marked as MISSING.
3. Review your code and see if you can modify it so these are no longer needed e.g. ActiveDS and DfrgUI
4. Otherwise try installing the DLL files. You may need to register them using regsvr32 before they can be used
If using 64-bit Access, you may find some external libraries do not work.
5. Check it works.
6. Make the same changes on your runtime machine and all should be fine

 

[Pat Hartman]

MS has switched to installing 64 bit Office by default instead of installing 32 bit Office. If you need the 32 bit version, you may have to uninstall Office and reinstall it and pay attention to the options. 32 bit libraries will may not run with 64 bit Office.