Charlotte Foust
charlotte.foust at gmail.com
Tue Jan 18 10:16:33 CST 2011
Yeah, I ran into this with password protected BE's too. It was simpler to use a constant for the password, but that pretty much eliminates the security unless you are distributing a runtime. What about storing the password in a library with restricted access? Charlotte Foust On Tue, Jan 18, 2011 at 7:57 AM, Rocky Smolin <rockysmolin at bchacc.com> wrote: > 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 >