[AccessD] Require password for linked MDB tables

But if I use the following to try to link...I get the error (invalid 
Password):

    Set tdf = dbs.CreateTableDef("Test")
    tdf.Connect = ";Database=C:\temp\test.mdb"
    tdf.SourceTableName = "tblPass"
    dbs.TableDefs.Append tdf


>From: "Bobby Heid" <bheid at sc.rr.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "'Access Developers discussion and problem 
>solving'"<accessd at databaseadvisors.com>
>Subject: Re: [AccessD] Require password for linked MDB tables
>Date: Wed, 18 Jul 2007 18:14:10 -0400
>
>I guess if you asked the user for the password before linking the table,
>then it might work.  You would have it unlink it after using it.
>
>Bobby
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
>Sent: Tuesday, July 17, 2007 3:49 PM
>To: accessd at databaseadvisors.com
>Subject: [AccessD] Require password for linked MDB tables
>
>Hello All,
>
>Can I have an MDB linked to a seperate MDB(with password)...and have the
>user required to enter just a password to view the linked table each time?
>
>And is it different in different versions?
>
>Thanks,
>
>Mark A. Matte
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
http://im.live.com/messenger/im/home/?source=hmtextlinkjuly07