Compacting an MSAccess Database with ADO.NET code (C#)

[Timothy]

Hello,

I'm wondering how to compact an MSAccess database from ADO.NET
The changes in filesize are amazing (when using the compact and repair
method in MS Access itself)

Thnx for any help.

 

[Miha Markic]

Hi Timothy,

Check out this article. It is for VB.NET but you shouldn't have problems
translating it to C#.
HOW TO: Compact a Microsoft Access Database by Using Visual Basic .NET
http://support.microsoft.com/default.aspx?scid=kb;en-us;306287&Product=vbNET