Users Not Prompted for Connection Password "Altemir" <david.altemir[ at ]gmail.com> 24.07.2006 13:47:47 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?

RE: Users Not Prompted for Connection Password Baz 24.07.2006 14:02:02 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" wrote: [Quoted Text] > > 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? > >

Re: Users Not Prompted for Connection Password "Altemir" <david.altemir[ at ]gmail.com> 24.07.2006 17:19:20 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"

Re: Users Not Prompted for Connection Password "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)> 24.07.2006 17:58:51 Simply leave the "Allow saving password" unchecked and the next times that the ADP file will be opened, Access will ask for the password. -- Sylvain Lafontaine, ing. MVP - Technologies Virtual-PC E-mail: http://cerbermail.com/?QugbLEWINF "Altemir" <david.altemir[ at ]gmail.com> wrote in message news:1153761560.076685.134200[ at ]75g2000cwc.googlegroups.com... [Quoted Text] > 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" >