Compacting and repairing access 2000 db

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John - 25 Mar 2008 02:17 GMT

Hi

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

Thanks

Regards

Reply to this Message

Spam Catcher - 25 Mar 2008 02:33 GMT

"John" <info@nospam.infovis.co.uk> wrote in news:#UcOvXhjIHA.340
@TK2MSFTNGP02.phx.gbl:

> 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

Signature

spamhoneypot@rogers.com (Do not e-mail)

Reply to this Message

William Vaughn [MVP] - 25 Mar 2008 19:04 GMT

Ah, no. It takes JRO. ADO does not have the needed methods and functions.

Signature

__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________

> "John" <info@nospam.infovis.co.uk> wrote in news:#UcOvXhjIHA.340
> @TK2MSFTNGP02.phx.gbl:
[quoted text clipped - 5 lines]
>
> http://support.microsoft.com/kb/230501

Reply to this Message

Spam Catcher - 25 Mar 2008 20:44 GMT

"William Vaughn [MVP]" <billvaNoSPAM@betav.com> wrote in news:F207E931-
0C96-4038-A86E-FD7D628E6C3F@microsoft.com:

> Ah, no. It takes JRO.

Isn't JRO part of ADO?

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

Signature

spamhoneypot@rogers.com (Do not e-mail)

Reply to this Message

William Vaughn [MVP] - 25 Mar 2008 21:14 GMT

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

Signature

> "William Vaughn [MVP]" <billvaNoSPAM@betav.com> wrote in news:F207E931-
> 0C96-4038-A86E-FD7D628E6C3F@microsoft.com:
[quoted text clipped - 4 lines]
>
> That's what the knowledge base article says. Ha Ha.

Reply to this Message

Spam Catcher - 25 Mar 2008 23:24 GMT

> Not in any build/deployment I've seen... but it's been awhile.
>
>> That's what the knowledge base article says. Ha Ha.

BTW, I was just being sarcastic ;-)

Signature

spamhoneypot@rogers.com (Do not e-mail)

Reply to this Message

Cor Ligthert[MVP] - 26 Mar 2008 05:57 GMT

> 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

Reply to this Message

Paul Clement - 26 Mar 2008 13:36 GMT

¤
¤ > 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)

Reply to this Message

Compacting and repairing access 2000 db

Free Magazines