Search code examples
ms-accessjetrepair

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

Solution

  • 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?