Access starts sudenly prompting for user password

[Dumboy]

I have a database that has been running for about 5 months. All the sudden starts prompting SOME of the users for a user name and a password<br><br>EG admin<br>password<br><br>No password has been set up for users or groups, and it was not doing it before..<br><br>any ideas?<br><br>Details<br>The DB is in a shared drive and everybody has access<br><br>no changes have been made to the design<br><br> <p>Dumboy.! Ouch.! .my brain.....<br><a href=mailto:spiderdesign@yahoo.com>spiderdesign@yahoo.com</a><br><a href= > </a><br>It's hard to think with only one neuron......Ouch.....!....it hurts when I think......!

 

[Guest_imported]

Changes had to have been made somewhere. The only way the database would ask for a password, is if someone intentionally set up users in the database. If you create a new database file, and import all tables and such from the old one to the new one, and then use the new database, you should have no problems... untill someone adds a user again. <p>John Vogel<br><a href=mailto:johnvogel@computerwiz.net>johnvogel@computerwiz.net</a><br><a href=

http://johnvogel.homepage.com>My

Home Page</a><br>Jesus is the Way, the Truth, and the Life:<br>
Without the Way there is no going;<br>
Without the Truth there is no knowing;<br>
Without the Life there is no living. —Anon.

 

[Dumboy]

This is what happened... <br><br>There is a security hole in Access (97 and 2000) if you are using IExplorer 4.0 or above<br><br>so the fix was to set up a password at the admin level, not on the DB itself but in Access. So users did the fix, but for some reason there is like a cloud on their minds that doesn't aloud them to remember things like that.<br><br>anyway this is how you fix the bug<br><br>1. Start Access without opening any databases<br>2. from the tools menu choose security<br>3. Select users and group accounts<br>4. Ensure that the Name on the user block is ADMIN<br>5.Go to the Change Logon Password tab<br>6. The Admin password should be blank fi it has never been changed. If it is not blank go to Step 8<br>7. Assign a password that you can remember to the Admin user<br>8. Click apply, then OK to exit the menu and close the window to exit Access<br><br>Sometimes I just think they should change the name to Microsoft Windbugs, shouldn't they? <p>Dumboy.! Ouch.! .my brain.....<br><a href=mailto:spiderdesign@yahoo.com>spiderdesign@yahoo.com</a><br><a href= > </a><br>It's hard to think with only one neuron......Ouch.....!....it hurts when I think......!