How to "unSplit" a split DB

[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

 

[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.

 

[Tony Toews [MVP]]

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/

 

[Klatuu]

I'm with Tony on this. Don't see the point.

 

[dave]

Thanks to all.
I will leave it as it is per Tony,

dave