Compacting and repairing access 2000 db

[John]

Hi

Is it possible to compact and repair an external access 200 database via
code?

Thanks

Regards

 

[Guest]

Is it possible to compact and repair an external access 200 database via
code?

AFAIK, you can't via ADO.NET. But you can use classic ADO.

http://support.microsoft.com/kb/230501

 

[Guest]

Ah, no. It takes JRO.

Isn't JRO part of ADO?

That's what the knowledge base article says. Ha Ha.

 

[Guest]

Not in any build/deployment I've seen... but it's been awhile.

BTW, I was just being sarcastic ;-)

 

[Cor Ligthert[MVP]]

BTW, I was just being sarcastic ;-)

I thought it was meant to help Bill.

As is proven is everybody using forever the same ways to solve things (and
tell about that).

In my idea does another light on that helps to improve that.

Cor

 

[Paul Clement]

¤
¤ > Ah, no. It takes JRO.
¤
¤ Isn't JRO part of ADO?
¤

Different library, actually an extension to ADO since it lacks the functionality - but they're both
installed via MDAC.


Paul
~~~~
Microsoft MVP (Visual Basic)