If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Database Network Setup
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!!! |
#2
|
|||
|
|||
Database Network Setup
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 "Golfinray" wrote in message ... 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!!! |
Thread Tools | |
Display Modes | |
|
|