Compact Access Database from CSharp

[Benny Raymond]

I realized that as I add and delete rows in my database that the size
never goes down... just up and up and up and ... well you get the
picture. I know that when you're working through access you can select
"Compact and Repair database..." from the Tools menu which removes all
of the rows that no longer exist... The only problem is that I cannot
figure out how to make the database do this from my program, add to the
fact that my users may not have Access, nor would I want them to have to
open up the database every once in a while and compact it if they did
have access.

So, is it possible to send a command over OleDb that compacts the database?

Thanks in advance,
Benny

 

[carion1]

No. Possibly through adox which involves interop. Take a look at VSTO or
just instantiate an Access object (again interop).

 

[Hugo Nugra]

You have to use the JRO library.

Add a reference to "Microsoft Jet and Replication Objects 2.6 Library" (COM component)

string FileSource = "MyAccessFile.mdb";
string SourceConnection = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + FileSource;
string DestConnection = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + "FileTmp.mdb";

if (System.IO.File.Exists("FileTmp.mdb"))
System.IO.File.Delete("FileTmp.mdb");

JRO.JetEngineClass objJet = new JRO.JetEngineClass();
objJet.CompactDatabase(SourceConnection, DestConnection);

System.IO.File.Delete(FileSource);
System.IO.File.Move("FileTmp.mdb", FileSource);

 

[Benny Raymond]

No. Possibly through adox which involves interop. Take a look at VSTO or
just instantiate an Access object (again interop).

instantiating an Access object requires the end user to have access
though right?

 

[carion1]

Yes. Take a look at VSTO. My guess is that will do what you want.

 

[Chris Priede]

Hi,

The only problem is that I cannot figure out how to make the database do
this from my program, add to the fact that my users may not have Access,
nor would I want them to
have to open up the database every once in a while and compact it if they
did have access. So, is it possible to send a command over OleDb that
compacts the database?

http://www.codeproject.com/cs/database/mdbcompact_latebind.asp