Password/Permission localization

  • Thread starter Thread starter Antonio
  • Start date Start date
A

Antonio

I have a database that is located on our office server.
The server runs Windows NT server I believe. Right now,
we have 18 computer work stations in our office, each
with at least Access 2000 on each, some 2002, some xp. I
currently have the same accounts and permissions set up
on each of the individual work stations. (quite a tedious
task as we have 32 employees) Is there a way to set the
permissions at the server vice each individual work
station. They just installed a new workstation last week.
After installation anyone could follow the link to the
database and open it with no prompts for passwords or
anything...giving that person admin abilities. There are
new parts of this database that are being opend to other
departments within our organization and this way of
database security administration seems a bit impossible.
I cant see myself going to every computer in the building
when ever there is a major change to the programs
secuirity settings.
Thanks in advance.
Antonio
 
You need to do several things here. In order for Access
security to work properly, you need to get rid of the
Admin user and replace it with a new Admin user (I call
mine Master) and transfer permissions so that the original
Admin user ends up with no permissions. You also need to
transfer ownership of the database object (and all others)
to the new admin user. Having secured the database, you
can then deal with the MDW file.

The MDW file is what deals with a lot of the security, and
you need to hold one copy of this centrally, rather than
on each machine. You can then direct the relevant database
on a client machine to that MDW via a desktop shortcut
icon with a path similar to the following:

"c:\program files...\Msaccess.exe" "path to MDB
file" /wrkgrp "path to MDW file"

Sorry if the explanation is a bit brief, but you could
always contact me directly for more, or invest in an
Access Security course (try Access Experts course at
http://www.equationonline.co.uk) or manual to get the full
story.
 
Not to answer your question, but: if a user can open your database *without*
using the proper workgroup file & logging-on with a valid username/password,
then, the database has not been properly secured - no if's, but's or
maybe's.

HTH,
TC
 
Back
Top