[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