Using Access by multiple users

[Ryan]

I have a stand alone PC that is being used to store
files. I have a Access database that I would like
multiple people to use and modify at the same time. As
far as I know more than one person can open the database
but only one person can modify it everyone else only has
read only access to it. Could someone please tell me how
to set it up so that 3 users can use it and modify it at
the same time?

Thanks in advance for your help.

 

[Nicky]

SO far as I know each file can only be edited by one user,
however, a file can read and write to data in another
file. So you can split your database into a 'front end'
containing forms, queries, reports etc, and a 'back end'
containing the tables. The 'front end' then links to the
tables in the 'back end'. Each user then has their own
copy of the 'front end' and they share the 'back end'.
When one user is writing to a record that individual
record is locked, but the other users can write to any of
the other records.
This method solves the problem if you wish to share data,
but doesn't help if you wish to share the 'front end'
parts of your database.

 

[Gina]

Try looking under
Tools
Options... click the Advanced Tab
Select 'No Locks" under Default Record Locking

I believe you have to do that for each machine. Hope that helps...