Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Access 97 not prompting for username and password

Posted on 2011-03-12
4
Medium Priority
?
247 Views
Last Modified: 2012-05-11
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!
0
Comment
Question by:animallover
  • 3
4 Comments
 

Author Comment

by:animallover
ID: 35119555
I had an old copy of my hssa.mdw file so I renamed the broken one and copied the backup into the same folder and voila it now prompts me for a UN and PW.  But it's a copy from over a year ago and I have added users since then.  Any idea how I can get my broken one to work again?
0
 
LVL 85
ID: 35121202
The "trigger" that causes ULS to prompt for a password is the existence of a non-blank password for the Admin user. If the Admin user's password in hssa.mdw has somehow become blank (i.e. no value) then it will no longer prompt users for a password.

I'd also encourage you to NOT "join" the hssa.mdw workgroup on the machine, as this can cause troubles for other databases on that machine. Use the workgroup utility to rejoin the default system.mdw file, and continue to use your shortcut with the /wrkgrp switch.

BTW, the fact that you can open your Shelter database with other workgroup files indicates that you haven't secured it properly. If you had, then when you tried to open it with the other workgroups you should have received the "You don't have permissions blah blah" error and Access should have not allowed you to in to the database. This might not be an issue if you're only goal is user navigation, but if you're trying to keep data secure, then understand that ULS isn't properly configured.
0
 

Accepted Solution

by:
animallover earned 0 total points
ID: 35243847
I only joined the database on the machine to see if it would make a difference.  Otherwise I use the switch.  Since I figured this out on my own how do I cancel or revoke my question?
0
 

Author Closing Comment

by:animallover
ID: 36243616
I figured it our on my own.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question