How can I undo a database split?

G

garry2022

I have carried out a database split as an experiment into what it did, but I
now need to move the files to another computer and I need to undo the split.
Any ideas on how I go about this?
 
D

Duane Hookom

I would open the front end and delete the links to the tables in the back
end. Then import the tables back in.

I'm not sure I have heard any justification for doing this...
 
W

Wayne Morgan

The split will move the tables into a second file and place linked tables in
the original file. To undo the split, delete the linked tables in the
original file and to a File|Get External Data|Import on the tables. However,
you don't need to do this just to move the files to another computer. Once
you have the files at the new computer, open the front-end file and go to
Tools|Database Utilities...|Linked Table Manager and relink the tables to
the new location of the back-end file.
 
Top