[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