network setup
in [Tables]
|
Prev: Multiple requests from one table.
Next: How do I split my database for multiple users in Access 2007?
From: magicdds on 26 Jun 2008 00:45 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
From: bhicks11 via AccessMonster.com on 26 Jun 2008 08:55 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 wrote: >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 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/200806/1
From: magicdds on 26 Jun 2008 23:29
Thank you "bhicks11 via AccessMonster.com" wrote: > 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 wrote: > >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 > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/200806/1 > > |