Users Not Prompted for Connection Password

  • Thread starter Thread starter Altemir
  • Start date Start date
A

Altemir

Not sure how this happened, but my Access 2003 ADP database is not
prompting users for a connection password. I looked in the database
Connection properties (i.e., Data Link Properties dialog) and noticed
that a password is being saved such that users are never prompted to
enter their own password. I didn't mean to save a password and it
won't allow me to blank out the password field. How can I undo this?
 
Open the code window, any module, and in the Immediate pane issue the
following command:

CurrentProject.OpenConnection ""

This will disconnect your project from the database. You can then reconnect
it correctly.
 
That does the trick as far as disconnecting the ADP, but how do I
reconnect?

It is still insisting that I enter a valid password. Shouldn't I be
leaving the password field blank so that user gets prompted for his
password at runtime? If I leave it blank, it won't let me select the
database to connect to (i.e., the "Initial Catalog"). I end up getting
the following error:

"Microsoft Access could not log onto the server. Verify that the logon
information is correct"
 
Simply leave the "Allow saving password" unchecked and the next times that
the ADP file will be opened, Access will ask for the password.
 
Back
Top