[AccessD] DBEngine.CompactDatabase - Supplying Passwordargument for currently open db.

    My sincere thanks Marty!  I shall explore the feasibility of adapting it to current version.

A.D.Tejpal
---------------

  ----- Original Message ----- 
  From: MartyConnelly 
  To: Access Developers discussion and problem solving 
  Sent: Wednesday, April 26, 2006 01:32
  Subject: Re: [AccessD] DBEngine.CompactDatabase - Supplying Passwordargument for currently open db.


  For 97 this was easy
  http://www.trigeminal.com/code/DatabasePassword.bas


  A.D.TEJPAL wrote:

  >    For making a back-up copy of currently open FE and then compacting this back-up copy, using  DBEngine.CompactDatabase method, database password if existing, has to be passed as the last argument, e.g.
  >
  >    DBEngine.CompactDatabase "SourceFilePath", _
  >                "DestinationFilePath", , , ";pwd=xyz"
  >
  >    Could there be a way to get the password for currently open db,  without prompting the user for it ?
  >
  >    Note - Application.CompactRepair method seems ruled out as it does not have any password argument in its syntax and instead prompts the user for it.
  >
  >TIA
  >A.D.Tejpal
  >---------------
  >  
  >

  -- 
  Marty Connelly
  Victoria, B.C.
  Canada