Hi Donna,
No. As Jerry indicates, each user needs to have the appropriate privileges
for the shared folder, so that Access can create the locking database file
(*.ldb). If this file cannot be created, then the first user in will have
exclusive access. Here is an article that discusses this in more detail:
Introduction to .ldb Files
http://support.microsoft.com/?id=299373
Regarding setting the default open mode to shared, this is only important if
you are sharing the entire database (ie. it has not been split). However, if
you are running an unsplit application, you are in serious risk of corrupting
your file. If the term "split" is unfamiliar, then please see these links for
more information:
Split the Database
http://www.access.qbuilt.com/html/gem_tips1.html#SplitDB
http://www.accessmvp.com/JConrad/accessjunkie/splitting.html
Finally, here is an article that you may find useful:
Implementing a Successful Multiuser Access/JET Application
http://www.access.qbuilt.com/html/multiuser_applications.html
Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
:
1. All users of the database must have at least read, write, and modify
privileges to the folder holding the database file. Not just the database
..mdb file, but the entire folder.
2. Open the database and go to Tools, Options, and Advanced Tab. Set the
Default Open mode to Shared and the Default Record Locking to Edited Record.
(While you are in the Options area, go over to the General tab and turn off
Compact on Close and Name AutoCorrect. Trust me on this.)
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
__________________________________________
:
Our Access database now resided on our Server. If one person opens the
database from te folder it is in on the server, then no one else can go to
the Access database from that shared folder on our server. Is that normal?
