Hardware

Ask something
Question Locked

MS Access Password Prompt

0 helpful
4 replies

by richardm

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

A user is trying to use a MS Access front end that is stored on a network drive; the Access .mdb file is used by others however when this user attempts to open the file she is prompted for a password though none has been set on this database.

The MS KB states that this error is due to the user having previously attempted to open a database with visual basic or an otherwise non access program. The only solution MS posits is to copy the database to another blank DB; this is not feasible. Nor do I believe that this user has attempted to open the database with anything but access.

4 replies

by richardm

Any idea why this problem limited to only one user?

by maevinn

Since other users can still get in without the prompt, I'd go for running a repair on the errant users Access installation and see if that clears it up. Also, make sure the user is opening the file properly--in other words, if there's a short cut, use the short uct, if there's not a short cut, don't use one. I've seen problems where an mde file is generated errantly, or where the user mistakenly tries opening the database with a shortcut that's connecting to and MDE or the lock file.

This discussion is closed to new replies.