joining split database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I split an Access 2000 database in Access 2007. How do I join it back
together so it is as it was previously?
 
You should be able to import the tables from the backend to the frontend
database. You will have to delete the linked versions of the tables and
rename the imported tables to the correct names. I would suggest you make a
backup of your databases before trying this.

--
David Conger
Software Development Engineer in Test
Microsoft Office Access

** This posting is provided "AS IS" with no warranties, and confers no
rights. **
 
First thing to do is to make a copy of your FE database.

Working on the copy only, delete all the linked tables.
Goto File | Fet External Data | import

Browse for the BE tables

Select all the tables from the BE and press ok

This will import all your original tables, Check the table relationships but
they should remain as you set them originally.

Hope this helps??

Mike B
 
Back
Top