Rocky Smolin
rockysmolin at bchacc.com
Tue Jan 18 09:59:21 CST 2011
P.S. If I manually delete the table links and relink them everything works OK. R -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Tuesday, January 18, 2011 7:58 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Password Problem Gary: Where I use DBEngine I had the pwd parameter without MS ACCESS; but it seemed to work OK. The problem I'm having is just opening a bound form or even running a query. There's something about the table link that's retaining the old password. And I stepped through the relinking code which I can trigger a la carte (just to see if relinking the tables through the code would work) and the connect string for the linked tables was null so it didn't refresh the link. Now, if I point to a different database, in this case the same file name in a different folder, it works. But changing the password on the same database does not apparently update the password in the link. TIA Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gary Kjos Sent: Tuesday, January 18, 2011 7:40 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Password Problem Found this several places regarding relinking code to password protected backends .... -------------------------------------- Figured it out. If you are connecting to a password protected BE, you HAVE to provide the OPTIONAL parameters as follows: DBEngine(0).OpenDatabase(strDBPath, False, False, "MS Access;PWD=xxx10") If you do not it just raises the password error. -------------------------------------- On Tue, Jan 18, 2011 at 9:29 AM, Rocky Smolin <rockysmolin at bchacc.com> wrote: > Dear List: > > This is a legacy app that the client asked me to put a password on the > back end. He also wants to be able to change the back end password > from time to time. So I gave him instructions on how to do that. > > However, after the password is changed the bound forms error out with > an invalid password. If I go to the database container and try to > open a linked table in datasheet view I get 'Not a Valid Password'. > > If I delete the table links and relink the table, all is OK. But I > cannot refresh the links with the Linked Table Manager in > Tools-->Database Utilities. > > There is relinking code but relinking to the existing back end doesn't > clear up the problem. In fact, the relinking code does not prompt for > the database password. > > The table links apparently have the old password in there somehow. So > I'm missing a step here. Obviously I don't want the user to have to > delete the table links and relink. > > What am I missing? > > MTIA > > > Rocky Smolin > > Beach Access Software > > 858-259-4334 > > Skype: rocky.smolin > > www.e-z-mrp.com <http://www.e-z-mrp.com/> > > www.bchacc.com <http://www.bchacc.com/> > > > > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- Gary Kjos garykjos at gmail.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com