I have a beginner question. I have an access database that has a back end file. I want to combine the two files back into one file again. How do I go about doing this?
Thank-you
Cheeco
Access back end file
Competent Performer
Windows 10 
Access 2016
I have a beginner question. I have an access database that has a back end file. I want to combine the two files back into one file again. How do I go about doing this?
Thank-you
Cheeco
Master of Nothing
Windows XP Access 2010 32bit
Make a couple of back ups first!!
Open the FE and delete the linked tables (and only the linked tables).
Import (not link) the tables from the BE into the FE. In A2010, go to the ribbon, EXTERNAL DATA, ACCESS..
Follow the prompts
Done......
Competent Performer
Windows 10 Access 2016
That did the Job. Thank-you very much
Master of Nothing
Windows XP Access 2010 32bit
You are welcome......
Back end is NOT creating lock file
Front End Db Error -- Back End file path not valid.
Moving a back-end file
Posting Permissions
Reply With Quote