Security Changes

  • Thread starter Thread starter John Bruen
  • Start date Start date
J

John Bruen

Is there any way to secure a database in Access 2003
without creating a workgroup? I don't want to do this
because every time a person opens access for any database,
they have to sign-on. I thought there was a way to create
the tables under a particular user and leave everyone sign
on as admin in the previous version.
 
I just did something like you are looking to do. There is
an excellent reference by Jack MacDonald at
http://www.geocities.com/jacksonmacd/AccessSecurity.html
(The standard MS help and FAQ files are very confusing.)

The basic method is to set up user-level security on the
database you want to protect, create a shared workgroup
file where all of your users can access it, set the
permissions on the database so that they do not allow
access to users not in the shared workgroup file, and then
specifically reference that workgroup file in the
shortcuts used to open the database, rather than having
users "join" the secure workgroup.

The document does an excellent job at explaining how, even
for a newbie like me. It also explains they why/why not
of "joining" a non-default workgroup (it advises not),
which may affect why your users always have to provide
logins.

One caveat: The document references Access 97, and there
have been a few significant changes, most of which you'll
be able to figure out. The one I had a little trouble
with is finding the "Workgroup Administrator." He
references a separate .exe file, but--at least in Access
2002, it's within Access, under Tools/Security.

Good luck.
 
Is there any way to secure a database in Access 2003
without creating a workgroup?
No.

I don't want to do this because every time a person
opens access for any database, they have to sign-on.
Click to expand...

Wrong. Read-up on using the /wkgrp switch of a shortcut to avoid that
problem.

HTH,
TC
 
Back
Top