I have a database that is in use (for several sets of data). I would like to split the data out into a basic data base with just the tables. I want to link the existing tables to a working data base (One DB will be the data and the other the operational engine.)
This will let me continue making modifications to the Engine without shutting the users down. When I make the changes to the engine I can then come in and replace the engine and re-link the data tables. Currently it appears to create new tables rather than letting me link the existing tables.
When I upgrade the engine I will be upgrading 3 or 4 installations.


I have done this in earlier versions of Access, but am just getting started with 07’. How can I do this, or is there an easier way to accomplish the same thing?

Thanks

jsbdiver