View Single Post
  #1 (permalink)  
Old March 29th, 2004, 12:44 PM
imaley imaley is offline
Authorized User
Join Date: Mar 2004
Location: , , USA.
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default Compacting Access Database problem

Hi :

is it possible to compact a password protected Access 2000 database from code? I tied this:

DBEngine.CompactDatabase "c:\backend.mdb", "c:\backend1.mdb", ";pwd=password"

but I get an "Invalid password" error. Yet the password correctly open backend.mdb without a fuss in normal circumstances.

Any help would be greatly appreciated.



Reply With Quote