Concurrent Users

[mromyn]

Hi -
I have an access database on a shared drive that needs to be used byt
several users, often at the same time.

Right now, if someone has it open, nobody else can open the mdb file. How
can I set this up to allow access for more then one user at a time? They
need to be able to add and update records through the same form.

Thanks,
Mel

 

[mromyn]

Perfect! Thank you!

I forgot to say make sure the default open mode db option is shared, not
exclusive.

Chris

Split the db into a front end and back end using the database splitter wizard.
The back end file contains the tables and relationships only and is put on
the network share. The front end contains everything else and the links to
the tables. A copy of this front end is put on each user's desktop.

Give each user read/write/modify permissions in the folder where the back end
file is.

Chris

Hi -
I have an access database on a shared drive that needs to be used byt

[quoted text clipped - 3 lines]

can I set this up to allow access for more then one user at a time? They
need to be able to add and update records through the same form.