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

Perfect! Thank you!
"Chris O'C via AccessMonster.com" wrote:

> I forgot to say make sure the default open mode db option is shared, not
> exclusive.
>
> Chris
>
>
> Chris O'C wrote:
> >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.
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/For...urity/200903/1
>
>