|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Concurrent UsersHi -
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 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 mromyn wrote: >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. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200903/1 I forgot to say make sure the default open mode db option is shared, not
exclusive. Chris Chris O'C wrote: Show quoteHide quote >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/Forums.aspx/access-security/200903/1 Perfect! Thank you!
Show quoteHide quote "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/Forums.aspx/access-security/200903/1 > > 
Other interesting topics
Split Database not allowing more than one user
MDE application cracking issues Password to Access back end file cannot access shared folder on mapped network drive menu options for users AllowBypassKey with an .MDE file Need to protect data input open a form Can't share info on Access mdb Security Warning in Access 2007 |
|||||||||||||||||||||||
