[AccessD] Invalid Password

Rocky,
    
    If your client needs to implement periodic change of BE password, it might be preferable to provide a convenient arrangement so that at the click of a command button in the front end, the BE password gets altered as desired, accompanied by re-linking of all linked tables, based upon new password.

    It is noticed that if the BE is password protected, conventional re-assignment of modified connect string (e.g.  tdf.Connect = "<<NewConnectString>>") becomes ineffective (without causing any error). If this is followed by the usual  tdf.RefreshLink statement, an error is encountered. 

    One way around the above hurdle could be to delete existing linked tables and replace the same by freshly linked ones. If this approach is acceptable, a suitable solution could be devised so that the user has simply to enter the new password and click a button in FE for automated change of BE password accompanied by freshly linked tables.

Best wishes,
A.D. Tejpal
------------

  ----- Original Message ----- 
  From: Rocky Smolin 
  To: 'Access Developers discussion and problem solving' 
  Sent: Friday, October 02, 2009 20:10
  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