If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Creating a Multiuser Database
Iam creating a mulitiuser Database where all the users are
entering Data. I am not able to get the inforamtion entered to be saved on a common table.\ For example, the Database is loaded on 7 desktops, the 7 individuals enter information on different screens. The information is only being saved on their individual computer, and not going to the linked tables. The database is located on a shares drive. What step am I missing? What do I need to do? I am at a complete standstill. Please help me. Thank You Angela |
#2
|
|||
|
|||
Creating a Multiuser Database
On Tue, 8 Jun 2004 18:28:42 -0700, "Angela Charsha"
wrote: Iam creating a mulitiuser Database where all the users are entering Data. I am not able to get the inforamtion entered to be saved on a common table.\ For example, the Database is loaded on 7 desktops, the 7 individuals enter information on different screens. The information is only being saved on their individual computer, and not going to the linked tables. The database is located on a shares drive. What step am I missing? What do I need to do? I am at a complete standstill. Please help me. You should use the Database Splitter wizard. There are TWO databases in play - a "backend" containing nothing but the tables, and a "frontend", of which you will have seven copies, one on each users' machine. The frontend will have linked tables, not local tables. It sounds like you may have tried to do this and somehow ended up with the tables imported rather than linked! Open one of the individual databases. Is there a little arrow next to each tablename in the Tables window? If not, the tables are local. You can use File... Get External Data... Link to link to the shared database. John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public |
Thread Tools | |
Display Modes | |
|
|