By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,027 Members | 1,261 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,027 IT Pros & Developers. It's quick & easy.

Problem with MS Access

P: n/a
I have a large database running on a Dell Server. There are aprox 10
users on the network accessing the database. I keep getting error
messages saying that a user on the network has the file open and
locked under "Admin". as far as I am concerned the admin has a
password and all users are NOT accesing the database with Admin
rights. Why does the database become locked on a irregular basis (it
is not dependent on machine or user) and how can I repvent it
happening. It is causing me a right headache as I have to keep
getting everyone to close the database so i can reboot the server and
then repair the file.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Access security is always "on" and the default login is the Admin user.

Split the multiuser database into front-end (queries, forms, reports,
macros, modules, and any infrequently-changed local lookup tables) and back
end (data, tables, and relationships). Give each user a copy of the front
end, and link the tables in the shared back end.

Although you may not have yet encountered a problem, having multiple users
logged in to the same front-end or monolithic database (as it seems yours
may be) significantly increases the probability of corruption.

For an introductory overview of multiuser, download the presentation I did
for my user group on that subject from http://appdevissues.tripod.com. For
the best collection of links and info on the subject, visit MVP Tony Toews'
site http://www.granite.ab.ca.

Larry Linson
Microsoft Access MVP
"Darren Rhodes" <da***********@yahoo.co.uk> wrote in message
news:c1**************************@posting.google.c om...
I have a large database running on a Dell Server. There are aprox 10
users on the network accessing the database. I keep getting error
messages saying that a user on the network has the file open and
locked under "Admin". as far as I am concerned the admin has a
password and all users are NOT accesing the database with Admin
rights. Why does the database become locked on a irregular basis (it
is not dependent on machine or user) and how can I repvent it
happening. It is causing me a right headache as I have to keep
getting everyone to close the database so i can reboot the server and
then repair the file.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.