Access 2016 database: move from old computer to new.

Question

I need to move my access 2016 database from my old computer to my new computer running Microsoft 365. How can I do that?

Answer 1

The database is split, can I still copy the database as Hans described or is it more complicated?

In that case, you should copy both the frontend and the backend from the old computer to the new one using any of the methods that I described.

If the folder path of the backend is exactly the same on the new computer as on the old one (e.g. it's in C:\MyDatabases on both computers), you're done.

If not, you must relink the tables in the frontend database to the backend on the new computer:

• Open the frontend database, holding down the Shift key to bypass the startup options (if possible).
• Activate the External Data tab of the ribbon.
• Click the Linked Table Manager button in the Import & Link group.
• Tick the check box 'Always prompt for new location'.
• Click 'Select All'.
• Click OK.
• Locate and select the backend database.
• Click Open.

Answer 2

I forgot to mention that my version of Office 365 does include Access. There are no special references or addins.

Answer 3

The database is split, can I still copy the database as Hans described or is it more complicated?

'What Hans said.

Answer 4

Thank you for your help, I really appreciate it!!