Users Not Prompted for Connection Password

[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?

 

[Guest]

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.

 

[Altemir]

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"

 

[Sylvain Lafontaine]

Simply leave the "Allow saving password" unchecked and the next times that
the ADP file will be opened, Access will ask for the password.