Error compacting password protected db

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

I get a Data Type Conversion Error whenever I try
compacting a database that is password protected using
the following code:

DBEngine.CompactDatabase "C:\Test\Data_CL.mdb", "C:\Test\D
ata_CL.CMP", DB_LANG_GENERAL, ";pwd=test"

Any help you can provide would be greatly appreciated.
The MS Help for CompactDatabase doesn't give too much
really discuss password protected files in detail (big
surprise).

Thanks

Mark
 
You need to add all options to the line for example:
DBEngine.CompactDatabase "C:\Test\Data_CL.mdb", "C:\Test\D
 
Back
Top