[AccessD] Password Problem

Rocky,
I found this link that may be helpful.

http://www.utteraccess.com/forum/linked-tables-password-p-t1900801.html

Also, I have seen Boyd on AccessD recently. He may have more info.

Good Luck,
Jack

On Tue, Jan 18, 2011 at 11:52 AM, Gustav Brock <Gustav at cactus.dk> wrote:

> Hi Rocky
>
> It is not "somehow" in the link -  it _is_ in the link information.
> Run this query:
>
> SELECT
>  MSysObjects.Name AS TblNameLinked,
>  MSysObjects.ForeignName AS TblNameSource,
>  RTrim([Database]) AS DbsFile,
>  RTrim([Connect]) AS DbsType
> FROM
>  MSysObjects
> WHERE
>  MSysObjects.Type=6
> ORDER BY
>  RTrim([Database]),
>  MSysObjects.Name;
>
> /gustav
>
>
> >>> rockysmolin at bchacc.com 18-01-2011 17:20 >>>
> Using a constant would work even though this is an mdb, except that  the
> user wants to change the password from time to time and I don't want him to
> have to come back for a code change every time.
>
> However, that only applies to opening the mdb with dbengine or currentdb -
> manipulating recordsets.  My problem is that I can't even open a query that
> uses a linked table.  That password is somehow, I think, in the link.
>
> Rocky
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>