DBEngine.CompactDatabase

[Kevin McCartney]

Hi TWIMC

I'm trying to compact a database that has a security password set, I'm
trying to use the following code:Hi TWIMC

I'm trying to compact a database that has a security password set, I'm
trying to use the following code:

DBEngine.CompactDatabase srcDatabase, dstDatabase, , , strPWD

where strPWD is delcared as a String and is set to strPWD = ";PWD:=accobra"

I know the password is correct but I get the following error message

'3031 Not a valid Password'

which kind of makes me think the strPWD should be a string but what else
would it be.

Any help on this would me much appreciated.

TIA
KM

 

[George Nicholson]

If you are passing
";PWD:=accobra"

I think it should be
";PWD=accobra"

If that doesn't work, try changing PWD to lower case (i.e., pwd), since
that's what the Help entry seems to consistently specify. While I very very
seriously doubt that's the problem, doesn't hurt to try and make sure that
it isn't.

HTH,