Remove the 'SPLIT' from a database

message from =?Utf-8?B?RGlhbm5l?= on 6 May 2004
Is it possible to 'rejoin' a database into one file after it has been successfully split?
 
John W. Vinson [MVP] replied to =?Utf-8?B?RGlhbm5l?= on 6 May 2004
it has been successfully split?

Yes; a bit tedious but not hard.

MAKE BACKUPS of frontend and backend. Open the frontend;
select all the Tables (linked tables) and delete them -
this just deletes the link, not the table.

Use File... Get External Data... Import to import the
tables from the backend.

Test thoroughly!

John W. Vinson/MVP
 
Tony Toews replied to =?Utf-8?B?RGlhbm5l?= on 06 May 2004
Why? If performance then see the Access Performance FAQ page at
http://www.granite.ab.ca/access/performancefaq.htm

Tony
 

Archived message: Remove the 'SPLIT' from a database (MS Access Forms)