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.Application
AccessApp.Application.CompactRepair("C:\Mydatabase .mdb", "C:\Temp.mdb")

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

[Herfried K. Wagner [MVP]]

"genojoe" <ge*****@discussions.microsoft.com> schrieb:

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.Application
AccessApp.Application.CompactRepair("C:\Mydatabase .mdb", "C:\Temp.mdb")

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

HOW TO: Compact a Microsoft Access Database by Using Visual Basic .NET
<URL:http://support.microsoft.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]

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

Crouchie1998
BA (HONS) MCP MCSE