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

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

I’ve never tried to compact a password protected database, but from the information within the Access help file I believe that you only need to specify the password “;pwd=” option if you intend to specify a new password in the newdb.

This should work

DBEngine.CompactDatabase "c:\backend.mdb", "c:\backend1.mdb"

regardless of the database being password protected as the "c:\backend1.mdb" should inherit the original password protection.

Hi:

thanks a lot for replying - I checked out your suggestions - but no joy I'm afraid. I'm coming to the conclusion that maybe it can't be done.

Ian

I wonder if someone could try this and let me know if it is in fact possible or not - I can't find any documentation on it - at least nothing that specifically refers to compacting a secured database from code... nothing that I can make work.

Thanks.

See if this will answer your question....

http://www.mvps.org/access/general/gen0041.htm

Kenny Alligood

Thanks, but it's not the current database I want to compact. I have a separate Access front end and back end - the back end has no code - just data - and it's pwd secured.

I want to compact the back end from the front end - works fine if the back end isn't pwd protected - but I can't get it to work when the pwd is on.

My research suggests it should work - but I haven't had much luck.

I found the answer elsewhere - for anyone who may be interested, the syntax is:

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

To those who replied - thank you for your help.