Compacting an Access database with VB.NET

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
genojoe said:
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?
Click to expand...

HOW TO: Compact a Microsoft Access Database by Using Visual Basic .NET
<URL:http://support.microsoft.com/?scid=kb;EN-US;306287>
 
I answered the same question yesterday in this newsgroup with the same MS
article

Crouchie1998
BA (HONS) MCP MCSE
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compacting an Access database with VB.NET 1
Repair an Access database from .NET 5
Copy and move Access 13 database on laptop to pc with Access 13 0
Compacting Access Database 5
Vb.net Ms Access Database 2007 Reusable Procedures/queries/functions 5
Error trying to connect to Access DB in VB.Net 2
Access Deleted Table after Compact and Repair Database (Access 2010) 0
Help with a batch file please 1

Back
Top