how do you set up a database to be used by multiple people on a s.

L

Linda

I have a database I would like to share with another employee on a shared
drive, how do I set this up?? Dealing with Access database
 
L

Lynn Trapp

1. Use the Database Splitter wizard to split the database into
Frontend/Backend. You'll want a copy of both files on the shared drive.
2. Put a copy of the Frontend on your machine and on each of the machines
of other employees who need access to it.
3. Create a desktop shortcut to the Frontend on each machine.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html
 
F

Fred Boer

Dear Linda:
Access databases are multi-user right out of the box. Splitting the database
is an essential part of creating a well-designed multiuser database
application. When you "split" a database, you create two separate .mdb
database files: one file holds the tables of data, and the other file holds
all the forms, reports and queries and so on. The file holding the tables
of data (often called the "Back End"), is stored in a shared folder on the
network server. All users need full permissions on this folder. Copies of
the file with the forms, etc., (often called the "Front End") are stored on
each workstation. The "Front End" .mdb database files are "linked" to the
Back End" .mdb database files, so that all users have access to the same
data. There is a database splitter tool available within Access to help with
the process.
There is good information here:
http://allenbrowne.com/ser-01.html
and here:
http://www.granite.ab.ca/access/splitapp/index.htm
Post back if you have further questions!
HTH
Fred Boer
 
Top