user unknown 1

[mgbeye]

I am trying to set up my security. When I start the database and the login prompt pops up it works fine if you enter the admin username and password. However, I have created a user that has limited access. When the login and password are entered it doesn't work. It says they are unknown. Anyone know what might be wrong??

Thanks!!

 

[RickSpr]

The user name and password are defined in the system database (a.k.a. Workgroup Information File); if you're getting an "unknown user" message, it means that user isn't in your current system db.

To switch system databases, use the Workgroup Administrator utility (wrkgadm.exe), which is installed in the same location as msaccess.exe. There are also other ways to use the correct system database with a particular application database. Look in the help docs under Workgroup Information File, Security, and Command Line Startup Options.

BTW, do not attempt to use the default system database (system.mdw in the Windows folder) to set up your security. The default one is meant to provide unrestricted access to all users by default. Even after you think you've plugged all the holes, it's very easy to get in the back door. You should always set up security using a system db created specifically for the purpose with its own secret Workgroup ID number. Rick Sprague