How to "unSplit" a split DB

D

dave

Access 2003

Database was split but no security put on it. Database was never really used
(just tested).
It has now been decided to go in a different direction but a good 80% of the
current development is usable.

I could continue the new work with the DB split but life would be easier if
I put them back togatther for the remaining development.

Will this be as simple a importing the tables from the back end split after
deleting the "linked" tables in the front end - or am I missing something.

Thanks,

dave
 
F

fredg

Access 2003

Database was split but no security put on it. Database was never really used
(just tested).
It has now been decided to go in a different direction but a good 80% of the
current development is usable.

I could continue the new work with the DB split but life would be easier if
I put them back togatther for the remaining development.

Will this be as simple a importing the tables from the back end split after
deleting the "linked" tables in the front end - or am I missing something.

Thanks,

dave

In the Front end, simply delete each linked table. This does not
delete the table, it just deletes the link.
Then click on File + Get External Data + Import.
Navigate to the back end database. Select all of the tables. Click on
Options. select Import Relationships and Table Definition and Data.
Click OK.
 
T

Tony Toews [MVP]

dave said:
Database was split but no security put on it. Database was never really used
(just tested).
It has now been decided to go in a different direction but a good 80% of the
current development is usable.

I could continue the new work with the DB split but life would be easier if
I put them back togatther for the remaining development.

Will this be as simple a importing the tables from the back end split after
deleting the "linked" tables in the front end - or am I missing something.

Yes, it is that simple. But how would life be easier if you put them
back together for the remaining development?

Copy the BE MDB to your computer. Link the FE MDB to that BE MDB on
your computer and work away. When you need to update the BE table
structure open it up separately.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 

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

Top