Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Access 97 not prompting for username and password

Posted on 2011-03-12
4
Medium Priority
?
244 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 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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
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…

715 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