Error compacting password protected db

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
 
G

Guest

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
Linking Tables from Password Protected DB 2
Cannot open password protected Access DB 7
DataGrid loading password protected MSAccess DB 1
Password protected documents 1
ISAM error when trying to create tablelink 21
TransferDatabase aclink on a password protected database 3

Top