Multiple users of a split database

  • Thread starter Thread starter PeterJC
  • Start date Start date
P

PeterJC

Recently I asked why my database (Access 2007) couldn't be used by multiple
users, and some of you recommended strongly that I should split the
database.
I've now split the database, with the back end on the network server,
and copies of the front end on the local hard drives of four users, with
another on my local hard drive as administrator.
If any of these copies is open, then a user cannot open the database,
with a message that the back end is in use (or words to that effect). But if
a user has the database open, the I can open my copy as administrator.

What am I missing, please?
 
Look at help on default record locking. Set it to edited record. Then make
sure the users have read\write\edit\and delete rights to the BE on the
network AND the folder it resides in.
 
Thanks, Milton, I'll look into that.
--
PeterJC


golfinray said:
Look at help on default record locking. Set it to edited record. Then make
sure the users have read\write\edit\and delete rights to the BE on the
network AND the folder it resides in.
Click to expand...
 
Back
Top