Programming

[Crystal]

I am confused on how to merge two databases together. We are working on a
networked system and we use a workgroup. They are the same databases but on
one computer the path name is not the same on the other computers and the
information is not all linking together, how can I merge the two so that they
link and have the same path to each other?

 

[V Ramos]

I am confused on how to merge two databases together. We are working on a
networked system and we use a workgroup. They are the same databases but on
one computer the path name is not the same on the other computers and the
information is not all linking together, how can I merge the two so that they
link and have the same path to each other?

Actually, you do not have to worry about the databases having separate
paths. Just create a separate shortcut for each databases in each user
using windows script (to automate the process if you have many users). And
if you want the databases to share information, just link the tables. Also,
if refresh of information is slow across the databases, i think u need to
requery all tables and queries when a user saves information.

V. Ramos