database splitting

[Guest]

I am developing an application that I want to start using, but I have not
completed all forms and reports. I don't want to "corrupt" the "real"
tables during further development testing and saw a suggestion that splitting
the database would allow me to do this. I tried it and it seems to work and
found out how to change the linking (relink) between the real tables and the
"working" tables (that are in different directories). My question is, is
there a way to re-combine the two files if I want to do that at some point?
I am not sure it will be necessary, but I don't like to venture down a path
of "no return".

Thanks -- Garry Gross

 

[Ken Snell [MVP]]

You recombine the two database files this way:

(1) In the front end, delete all the linked tables.
(2) From the front end, use File | Get External Data | Import menu to import
all the tables and data from the back end file.

 

[Douglas J. Steele]

However, I can't think of a single legitimate reason to need to!

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

 

[Ken Snell [MVP]]

One of those nights when you can't sleep and need to do something to make
yourself tired...?

 

[Default User]

One of those nights when you can't sleep and need to do something to make
yourself tired...?