Solved

Access 97 not prompting for username and password

Posted on 2011-03-12
4
221 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
I figured it our on my own.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

771 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now