[AccessD] Invalid Password

Rocky, it sounds as if you have hardcoded the password somewhere in the
coding or in a shortcut which launches the FE. Could you do a text search
for the earlier password from any of the modules code windows.?

Max

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: 02 October 2009 15:41
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Invalid Password

Dear List:

I have an app FE/BE with the BE password protected.  I prompt for the
password when the front end opens.  Been running fine.

Now the client asks to change the password every month or so, so I show him
how to open the back end exclusive, unset the password, reset the password.
That works.

But when I open the front end, give the password, now trying to open one of
the linked tables gives 'Invalid password' message.  None of the queries
which reference a linked table work - 'invalid password'. 

If I manually delete the links and manually relink it almost works.  If,
after the manual relink, I close and reopen, it works.  

What am I missing here?

 

MTIA,

 

Rocky