[AccessD] Invalid Password

A.D.:

I understand and that looks like a good solution - I prefer functions that
work through the front end with a button click - keeps the user out of the
OS.

But to change the password on the back end I believe you need to open the BE
exclusive.  So how can you change the BE password through the front end?

Thanks and regards,

Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com
www.bchacc.com
 
 


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of A.D.Tejpal
Sent: Sunday, October 04, 2009 8:29 PM
To: Access Developers discussion and problem solving
Subject: Re: [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
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com