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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split database before or after sending out 1
Mobile phone texts split into incoming and outgoing messages 0
How do I copy the front end database to the second PC? 4
storing calculated values from forms into a database file 1
Upgrade from 97 to 2003 and Splitting Database 1
List found strings on sheet 34
How do I share an Access Database 2007 (Vista) with other workers? 5
Access convert ms access 2007 database replica to design master 2

Back
Top