p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   SQL Language (http://p2p.wrox.com/forumdisplay.php?f=100)
-   -   Compacting Access Database problem (http://p2p.wrox.com/showthread.php?t=11131)

imaley March 29th, 2004 12:44 PM

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.

Thanks,

Ian



happygv April 23rd, 2004 11:28 AM

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


All times are GMT -4. The time now is 05:35 AM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.