Multiple users

M

mmmm

How do i give 5 users from 5 different machine access to my database? I want
all of them be able to enter or update data in the database at the same time.
Is this possible?
 
V

Van T. Dinh

Yes but you should split your database application to Fornt-End and
Back-End. The Back-End contains only the Tables and resides on a shared
folder that all users can access. The Front-End contain all other Access
objects and each user should have a copy of the Front-End on his/her
desktop.

Check Access Help on splitting a database.
 
J

John Vinson

How do i give 5 users from 5 different machine access to my database? I want
all of them be able to enter or update data in the database at the same time.
Is this possible?
Click to expand...

Possible and routine. It's best to use the "Database Splitter Wizard"
in the Tools... Database Utilities menu; this will split your database
into a "frontend" with the forms, reports, queries and so on, linked
to a "backend" (named by adding _BE to your current database name)
containing the tables. Each user gets a copy of the frontend, and can
share the table data in the backend. They'll only clash if two users
attempt to edit the exact same record at the same time.

John W. Vinson[MVP]
 
J

John Vinson

Can u explain this method step by step b'coz im not clear with this.
Click to expand...

Make a backup of your database.

Open the database.

On the menu select Tools... Database Utilities... Database Splitter.

Follow the instructions.

Access will create a new .mdb file by appending _BE to the database
name; this is the "backend" and will contain the Tables (and nothing
else). The .mdb file that you started with will now contain only links
to the tables, not the tables themselves, and all your queries, forms,
reports and so on.

It can be copied so that each user has a copy on their own computer;
the backend database should be put onto a shared drive to which
everyone has full read/write/create/delete access.

John W. Vinson[MVP]
 
Top