[AccessD] [SPAM SUSPECT] Re: [SPAM SUSPECT] Password Protected Database in a Bound Form

If you refreshed the table links after changing the password, I think this
might not have happened.

Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin -
Beach Access Software
Sent: Tuesday, July 18, 2006 1:38 PM
To: Access Developers discussion and problem solving
Subject: [SPAM SUSPECT] Re: [AccessD] [SPAM SUSPECT] Password Protected
Database in a Bound Form
Importance: Low


Yeah.  Bound for has a record source of tblSettlementWorksheet which is 
a linked table, but I put the password on after the tables were linked 
so that the DAO recordsets would require the password.  Put a text box 
on the opening form to collect the password into a global variable. 

However, I just relinked the tables and now the form with the linked 
table as the record source works.

Not sure I'm out of the woods here.  But at least I'm moving again.

Tnanks.

Rocky


Bobby Heid wrote:
> The bound form should be bound to linked tables, unless I am not
> understanding something.
>
> Bobby
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin -
> Beach Access Software
> Sent: Tuesday, July 18, 2006 1:10 PM
> To: Access Developers discussion and problem solving
> Subject: [SPAM SUSPECT] [AccessD] Password Protected Database in a Bound
> Form
> Importance: Low
>
>
> Dear List:
>
> The back end has a password.  Opening a recordset is no problem.  But 
> when I open a bound form I get the invalid password error because I 
> obviously haven't told the form what the password is.  How do I do 
> that?  The password is already in a global variable - if that helps.
>
> MTIA,
>
> Rocky Smolin