[AccessD] Password on the Backend

The BE is access.  The tables are linked. So I'm not opening any tables in
the backend when I open the form.  But it is bound to a linked table.

Rocky' 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Friday, May 29, 2009 1:30 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Password on the Backend

What is your BE are you using? How are you connecting to it? In ODBC the
username and password can be either be built in or it will make a login
request with each new connection. ADO-OLE once connected, stays connected
until you exit the application. When using ODBC, I just save the username
and password in variables and apply them as parameters with each request to
the BE.

This is off the top... so sorry about the lack of specifics.

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Friday, May 29, 2009 1:19 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Password on the Backend

Dear List:

I put a password on the back end and prompt for it in a pop-up in the
opening form.

However, now when I click a command button to open another form I get an
'invalid password' error.  It doesn't look like the _Open event of the
called form is executing.  But the form is bound to tables linked to the
back end.  

Does the OpenForm need a password parameter?  Or what am I missing here?

 

MTIA

Rocky Smolin

Beach Access Software

858-259-4334

www.e-z-mrp.com <http://www.e-z-mrp.com/> 

www.bchacc.com <http://www.bchacc.com/> 

 

 


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com