Hi, John.
Most likely, at least one of your users is opening the database without
adequate Windows security permissions, thereby locking other users out of the
database. For information on several methods of guaranteeing multiuser
access to Access databases, please see the following Web page for a link to
the article, "Multiuser Databases":
http://www.Access.QBuilt.com/html/articles.html
And if the front end weren't shared from the network, this problem could be
avoided, too. Each user should have a copy of the front end located on his
own workstation to help prevent database file corruption and any interference
with other users' lack of adequate Windows security permissions. For more
information on this, please see the Gem Tip, "Split The Database" on the
following Web page:
http://www.Access.QBuilt.com/html/gem_tips.html#SplitDB
HTH.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are (e-mail address removed) and (e-mail address removed)
Yellow Page info: Scott Ripley - (304) 863-9540 - Rr 3 Box 269a,
Washington, WV 26181
- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that questions
answered the quickest are often from those who have a history of rewarding
the contributors who have taken the time to answer questions correctly.
