[AccessD] Password Problem

Jack:

In that thread is noted "Probably because you are not storing the password
when you linked the tables. "

How does one store the password when linking the tables?

Rocky
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jack drawbridge
Sent: Tuesday, January 18, 2011 9:33 AM
To: Access Developers discussion and problem solving
Subject: Re: [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
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com