HOW TO: Compact a Microsoft Access Database by Using Visual Basic .NET
Wow.....Again, I am creating an Windows Application which the DB is Access97, as most of the computers are win98 only. And so, I found out the .mdb file is getting bigger and bigger while it add and delete a lot of data.
So.....have to find out a way to compact it without opening it.(As I rename the file extention to .mdbx and so noone will try to double click on it and have a look on it.....heheheheh, .mdbx......Access.NET? v1.0 or v1.1? hahahah)
And sure, lucky that I found it. And I would like to be share with you all althought that it is not a new technology. But I do sure there are many programmer/developer is being same situation as I am being, doing solution with Access.
Neither ActiveX Data Objects (ADO) nor ADO .NET provide the means to compact or repair Microsoft Access databases. However, you can accomplish this task by using the Microsoft Jet OLE DB Provider and Replication Objects (JRO) that was introduced with Microsoft Data Access Components (MDAC) version 2.1. ADO .NET allows the use of COM-based object libraries through the Interop layer.
Microsoft Jet OLE DB Provider and Replication Objects (JRO)