Error trying to compact database

[PaulBarter]

I get the error "ActiveX component can't create object" when trying to compact a database when trying to run on a different PC.

I am using the recommended code:

Dim jro As jro.JetEngine
Set jro = New jro.JetEngine
jro.CompactDatabase xxxx,yyyy

but it fails on the Set command

I have reference to Microsoft Jet & Replication Object 2.6 Library (msjro.dll)

This run fine on my development PC.

What am I doing wrong?

 

[ChrisHirst]

is the JRO library installed and registered on the other machine?

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum

 

[PaulBarter]

Well it certainly exists, but I will have to check if it is registered on that PC

 

[PaulBarter]

Sorry for delay in posting. It took me a few days before I got on site again.

You are right - for some reason it was not registered on that pc. I wonder why.

Working ok now.
Thanks

 

[dilettante]

I'd blame some other application that was packaged using "No-No Setup."

When a rustic uses that tool they often misdeploy system libraries, and quite commonly when a "No-No'd" program is uninstalled it pulls the rug out from under any other applications using a shared library by unregistering it and deleting the misdeployed secondary copy.

The original system copy is left behind but unregistered.

Just say no to "No-No.