Creating a Multiuser Database

  • Thread starter Thread starter Angela Charsha
  • Start date Start date
A

Angela Charsha

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
 
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.
Click to expand...

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.
 
Back
Top