JetComp

[Guest]

Is there a way of running JetComp from a VB6 app without requiring any user
intervention?

 

[Douglas J. Steele]

Do you really need JetComp, or can you simply use the CompactDatabase method
of the DBEngine object?

Another option might be using JRO:
HOWTO: Compact Microsoft Access Database via ADO (Q230501)
http://support.microsoft.com/?id=230501
Q7) How do I compact an Access database?
http://www.able-consulting.com/ADOX_Faq.htm#Q7

 

[David W. Fenton]

Do you really need JetComp, or can you simply use the
CompactDatabase method of the DBEngine object?

Another option might be using JRO:
HOWTO: Compact Microsoft Access Database via ADO (Q230501)
http://support.microsoft.com/?id=230501
Q7) How do I compact an Access database?
http://www.able-consulting.com/ADOX_Faq.htm#Q7

JRO, like ADO, is deprecated, because JRO is just one of the ugly
stepchildren of ADO. There is no advantage to using JRO over the
CompactDatabase method of the DBEngine object, which is available
even when you don't have a DAO reference set.

 

[Douglas J. Steele]

As long as you've got DAO loaded on the PC, you can use CompactDatabase.

If you don't have DAO loaded on the PC, that implies you're unable to read
the data from the file, so why do you need to be able to compact it?