Solved

Access 97 not prompting for username and password

Posted on 2011-03-12
4
233 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 84
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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

734 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