Hello,
I've been using the interop.jro.dll to compact the Access database my
aplication uses. After setting a password for the database and changing my
oledb connection settings to include that password, I can no longer compact
the database. I get an error saying "Not a valid password." The code I've
been using to compact is:
....
Dim jro As JRO.JetEngine = New JRO.JetEngine()
jro.CompactDatabase("Provider=Microsoft.Jet.OLEDB. 4.0;Data Source=C:\Program
Files\TestMaster\TestMaster.tmd", "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\Program Files\TestMaster\TestMaster2.tmd;Jet OLEDB:Engine Type=5")
....
..tmd is my own extension
This code creates a second compacted database "TestMaster2", which I then
rename to TestMaster1. After I set the password, though, this code brings
the aforementioned error. All other aspects of accessing the database work
fine, though.