Linking Tables between databases without Union Query

D

dogpigfish

I am trying to copy several user databases so that more than one can be
accessed at a time. However, I want all the tables from each database to
link into eachothers in the same table. Can I do this without having to
create several tables and merging them together in a Union Query. I have no
problem doing it this way, however I think there is a shortcut to doing this.
 
O

Ofer

If you have a server or a common directory that all the users can access,
then the right thing to do is create another Db that holds all the tables,
and all the users will be linked to the tables in that DB.
That way when you have a new version, when you give it to the users you dont
have to worry about the data, you wont touch it.

and all you have to do is backup the data once in a while
 
O

Ofer

If you have a server or a common directory that all the users can access,
then the right thing to do is create another Db that holds all the tables,
and all the users will be linked to the tables in that DB.
That way when you have a new version, when you give it to the users you dont
have to worry about the data, you wont touch it.

and all you have to do is backup the data once in a while
 
Top