Multiple User in a Database

  • Thread starter Thread starter Julie Gilliam
  • Start date Start date
J

Julie Gilliam

I have a database that I put on a Network Drive so that other people can add
data to it. How can I have this database to be able to let more than one
person add data to it at a time? Or is there a way? Thanks Julie
 
Good question. I hope someone who knows what the heck is going on with access
can respond to this!
 
Putting a multiuser database on a network is very dangerous. Sooner or later
your database will corrupt and become toast. The correct thing to do is
split your fatabase into a backend (tables only) and front end (everything
else). Put the backend on the network. Then from the frontend, link to the
tables in the backend. Finally, give each user a copy of the frontend. This
setup will let more than one person add data to the database at a time.

Steve
(e-mail address removed)
 
Every user should have read/write/create/delete permssions to the folder
containint the back-end MDB.
 
Back
Top