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.
