Groups | Blog | Home
all groups > dotnet ado.net > march 2008 >

dotnet ado.net : Compacting and repairing access 2000 db


John
3/25/2008 1:17:02 AM
Hi

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

Thanks

Regards

Spam Catcher
3/25/2008 1:33:17 AM
"John" <info@nospam.infovis.co.uk> wrote in news:#UcOvXhjIHA.340
@TK2MSFTNGP02.phx.gbl:

[quoted text, click to view]

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

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



--
William Vaughn [MVP]
3/25/2008 11:04:19 AM
Ah, no. It takes JRO. ADO does not have the needed methods and functions.

--
__________________________________________________________________________
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)
____________________________________________________________________________________________
[quoted text, click to view]
William Vaughn [MVP]
3/25/2008 1:14:01 PM
Not in any build/deployment I've seen... but it's been awhile.

--
__________________________________________________________________________
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)
____________________________________________________________________________________________
[quoted text, click to view]
Spam Catcher
3/25/2008 7:44:16 PM
"William Vaughn [MVP]" <billvaNoSPAM@betav.com> wrote in news:F207E931-
0C96-4038-A86E-FD7D628E6C3F@microsoft.com:

[quoted text, click to view]

Isn't JRO part of ADO?

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

--
Spam Catcher
3/25/2008 10:24:00 PM
"William Vaughn [MVP]" <billvaNoSPAM@betav.com> wrote in
news:1CBAB1DE-A82E-483E-A980-C34A3534157A@microsoft.com:

[quoted text, click to view]

BTW, I was just being sarcastic ;-)

--
Cor Ligthert[MVP]
3/26/2008 5:57:27 AM
[quoted text, click to view]
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
3/26/2008 7:36:46 AM
[quoted text, click to view]

¤
¤ > 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
~~~~
AddThis Social Bookmark Button