Hi all.
I designed an access application and set up users and group permissions. It
works fine in my pc, but as soon as I execute the application on another pc
ot doesn't prompt for any password and the user can have access to any object
in the DB. How could I prevent that? Thank you in advance.
I would presume because you set up workgroup security incorrectly. My guess is
that the new computer has its own SYSTEM.MDW file; the one on your computer
contains the usernames, user groups and passwords, and the default SYSTEM.MDW
on the other computer has only one user named ADMIN with no password. I'll
wager that you did not remove ADMIN's permissions, an essential step in the
security process.
If you have not done so already, download the Microsoft Access 2000 Security
FAQ:
http://support.microsoft.com/kb/207793/en-us
Print it out. Read it *carefully*, cover to cover. Get a good night's sleep;
read it again, even MORE carefully. Start from scratch on the backup (you
*did* make an unsecured backup... right...!?) and redo the security
completely, because if you weren't following this guide or an equally through
one, it's a certainty that your security is done WRONG.
Do note that Workgroup Security has been removed from A2007's new .accdb
format. It will still be honored in .mdb files under 2007, but I'm not sure
that you can use 2007 to apply security to a database.
