Compacting a password protected database using vba

  • Thread starter Thread starter Nick
  • Start date Start date
N

Nick

I'm trying to use the CompactDatabase command to compact a password protected
database but keep getting 'Not a valid password' message. I'm positive I'm
supplying the correct password but am possibly getting the syntax wrong eg.

DBEngine.CompactDatabase "dbtocompact", "newcompateddb", ";pwd=actualpassword"

Anyone know what I'm doing wrong please?
 
Back
Top