Multiple users of a split database

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?
 
G

golfinray

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.
 
P

PeterJC

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top