Database Network Setup

[Golfinray]

I would simply like to put a database on a network drive with no security so
that four users can use it. I have tried the security wizard and all the
security setup and was not successful. I need the users to be able to open
forms on a little switchboard I created and add data to the forms and it save
in tables. Now, if one user is in, the rest can see data but can't enter
data. Do I need to split or what? Thanks so much!!!

 

[Jeff Boyce]

If you've put an unsplit Access .mdb file on a network and tried to allow
multiple users to get at it, you will find poor application performance,
poor network performance, and a very real risk of corruption.

If you split your database into a back-end (data/tables only), you can put
that on your network, in a location that ALL your intended users have
Read-Write permissions to. The front-end (everything but the tables) needs
to have one copy per user, on each user's PC, linked to the tables in the
network-located back-end.

Regards

Jeff Boyce
Microsoft Office/Access MVP