JETCOMP.EXE arguments

I want to compact an access MDB database file using JetComp.exe . I want to pass the name of the file ( and the destination file) to Jetcomp.exe . However, JetComp.exe does not seem to respond. I tried the following:

jetcomp.exe -src:{"G:\my database.mdb"} -dst:"G:\my compacted database.mdb"                                                 

I can't use the GUI version of Jetcomp.exe as I want to include the line above in a database upgrader. 开发者_如何转开发

All the best, Seb

---

Use the DBEngine.CompactDatabase method instead of JetComp. One less thing to distribute.

I also go a bit further. See Backup, do you trust the users or system administrators?

---

ssc is correct. JetComp works! If the database is password protected use this syntax

jetcomp.exe -src:"G:\mydatabase.mdb" -wPASSWORD -dest:"G:\mycompacteddatabase.mdb"

---

Although the question is quite old, I'd like to post an answer since using JetComp may still be of use for someone.

However, JetComp.exe does not seem to respond.

Because you used the wrong syntax. This is how it works:

jetcomp.exe -src:"G:\my database.mdb" -dest:"G:\my compacted database.mdb"

---

JRO does not repair the database so Jetcomp is the better alternative. JRO is not able to open a corrupt database to perform a repair. Jetcomp does not attempt to open the database so it is the best option for DB repair and file compression.

Corrected command from above:

jetcomp.exe -src:"G:\my database.mdb" -dst:"G:\my compacted database.mdb"