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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compacting remote password-protected db 4
Compacting a password protected database using vba 0
Compact another DB within a Code 1
Access 2007 Data Base Compact via VBA 10
Need code to compact a secured database 9
DBEngine.CompactDatabase Compile Error: Argument not Optional 1
Linking Tables from Password Protected DB 2
ISAM error 4

Back
Top