Rocky Smolin
rockysmolin at bchacc.com
Fri Oct 2 13:23:30 CDT 2009
Max: That was my first thought too but no - no hardcode. Password's carried in a global variable. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo Sent: Friday, October 02, 2009 7:54 AM To: 'Access Developers discussion and problem solving' Subject: Re: [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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com