Workgroup admin

[Matthew Reed via AccessMonster.com]

I have an access front end which I distribute to users in a corporate
environment, and they put it on their local desktop. It's a .mdb file with
links to another .mdb back end, which is on a network drive.

To implement security I've created a workgroup with some simple groups in
it, and I've joined that workgroup. But, before others join the workgroup,
the database appears to be unsecured. Anyone with MS Access on their
machine can get into the database. Any new Access installs can have full
access to the database before they join the workgroup.

This seems blatantly unsecure. Any suggestions? Maybe a special network
folder that limits people's rights to it?

 

[Alex White MCDBA MCSE]

Hi Matthew,

Don't use network security, it does not do the same as access security, if I
can remember correctly, if you are not using the workgroup file you are
logging in as Admin, so I think you need to revoke that users privilege, and
you use another user account as the main admin account. It's been 5-6 years
since I used Access security, so I could be wrong. The only thing I can be
sure of is don't use network security it will not do what you want.

 

[Rick B]

You did not follow the proper steps to secure your database. The only
people you locked out are the ones that join the workgroup you built.

You need to read and reread the security FAQ, make a backup of your
database, then follow ALL the steps IN ORDER.

Good Luck.

Security FAQ

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



The Security Whitepaper is also worth reading to help you understand.

http://support.microsoft.com/?id=148555



Joan Wild:

www.jmwild.com/AccessSecurity.htm



Lynn Trapp

http://www.ltcomputerdesigns.com/Security.htm