network setup

[magicdds]

I have DB1, a database that has my tables.
DB2, a database that has my forms and queries. The tables for DB2 are linked
to DB1.

Computer1 is the server. DB1 resides on computer1.
DB2 also resides on computer1.

When I open DB2, the forms work fine.

Now if I go to computer2, I have 2 options:
1) Create a shortcut to open DB2 on computer1
2) Make a copy of DB2 and install DB2 onto computer2

Either way I get an error because the linked tables are looking for DB1 on
the C: drive of the computer on which DB2 is being run, but the tables are on
computer1.
I don't want to open DB2, in design mode, on each computer to link the
tables to DB1 on computer1 because when the database design is finished, I
want to create a run time version of DB2 to give to the users of all
workstations, that they can install on their computer and run the program.
DB2 needs to automatically link to the tables in DB1 on computer1.

I'm sure this can be done, I just don't know how. Can anyone help?

Thanks

Mark

 

[bhicks11 via AccessMonster.com]

I would copy DB2 to the local PC you are working on. You can re-link the
tables, used mapped drives in DB2 so that it works from any PC with the
mapped drives or UNC reference that will work on any machine wether drives
are mapped or not. I use mapped drives but I have a small business with a
controlled environment.

Bonnie

http://www.dataplus-svc.com

 

[magicdds]

Thank you

I would copy DB2 to the local PC you are working on. You can re-link the
tables, used mapped drives in DB2 so that it works from any PC with the
mapped drives or UNC reference that will work on any machine wether drives
are mapped or not. I use mapped drives but I have a small business with a
controlled environment.

Bonnie

http://www.dataplus-svc.com