Compacting an Access database with VB.NET

[genojoe]

I want to install a VB.NET application that uses an Access database on a
computer that does not have Microsoft Access installed. I want to compact
the database on occasion. If Access was installed I could use something like:

Dim AccessApp As New Access.Applicat ion
AccessApp.Appli cation.CompactR epair("C:\Mydat abase.mdb", "C:\Temp.md b")

Without Access on the computer, this code does not work. Is there an
alternate way to compact the database?

[Herfried K. Wagner [MVP]]

Re: Compacting an Access database with VB.NET

"genojoe" <genojoe@discus sions.microsoft .com> schrieb:[color=blue]
>I want to install a VB.NET application that uses an Access database on a
> computer that does not have Microsoft Access installed. I want to compact
> the database on occasion. If Access was installed I could use something
> like:
>
> Dim AccessApp As New Access.Applicat ion
> AccessApp.Appli cation.CompactR epair("C:\Mydat abase.mdb", "C:\Temp.md b")
>
> Without Access on the computer, this code does not work. Is there an
> alternate way to compact the database?[/color]

HOW TO: Compact a Microsoft Access Database by Using Visual Basic .NET
<URL:http://support.microso ft.com/?scid=kb;EN-US;306287>

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>

[Crouchie1998]

Re: Compacting an Access database with VB.NET

I answered the same question yesterday in this newsgroup with the same MS
article

Crouchie1998
BA (HONS) MCP MCSE