[AccessD] Password Problem

Rocky,

I don;\'t know any details. I saw your question and found a link. It seemed
to me that Boyd and EasyMoney49 had a process that both agreed worked.
Just passing on some info that seemed relevant and had a "seconder".

Jack

On Tue, Jan 18, 2011 at 1:08 PM, Rocky Smolin <rockysmolin at bchacc.com>wrote:

> 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>