Security

  • Thread starter Thread starter alv
  • Start date Start date
A

alv

I am having problems with Security. I have a database
sitting on a server. If I go to Computer A and fill in
all the users and passwords, from that computer it works
fine, From other computers the same access database does
not see the users set up.

Is this a local security issue? Shouldn't the security
feature be attached to the MDB?

Are there ways to centralize the security list so it is
set up on one computer and all computers see it.

You help in this would help greatly.
Thanks
Al
 
There is much more to security than just filling in users and passwords, and
if that is what you did then you modified the standard system.mdw that
Access uses for every session.

Security is tied to an Access session, not a specific database. The
permissions are stored in the mdb, while a workgroup file (extension mdw)
defines the groups, users and their memberships. When you start Access you
are joined to some workgroup. Even if the database isn't secure, you are
joined and use the system.mdw workgroup, which silently logs you in as the
'Admin' user.

Implementing security is not trivial. You need to download and study the
security FAQ available from

http://support.microsoft.com/?kbid=207793

Be sure to follow every step outlined or your database won't be secure.

If you hit any snags, or have further questions, I suggest you post in the
Access security newsgroup.
 
Back
Top