I am using an Access 97 database named "Shelter" which uses an mdw file (hssa.mdw) with usernames and passwords. I have been using it forever this way with no problems. I have /wrkgp in the shortcut as well as I have run the wrkgrp.exe file and pointed to the .mdw. The problem is that all of a sudden it is not prompting for the username and password and just logging people in as Admin. The admin user does not have full permissions to the database. I have different .mdw files that are used for other databases and if I use one of them to open "Shelter" it prompts me for the UN and PW. Any idea whats up with hssa.mdw?
Thank you in advance for your help!