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.

Thanks,

Ian

Not getting any clue on that. But you can give a try on this.
Test opening the database programatically.

Set d = OpenDatabase("DBPass.mdb", True, False, ";pwd=newpassword")

See if this succeeds. Will try and find the reason.

-Vijay G