CODEWITHSUNDEEP
c#databasems-access
Hossein Moradinia
Hossein Moradinia

Reputation: 6244

Compact Access 2007 DataBase File In C#

I want Compact a Access DataBase File in C# by Code. please Help me

Edited: I USe Microsoft Access 2007 DataBase File

Upvotes: 0

Views: 2050

Answers (3)

maxhugen
maxhugen

Reputation: 1944

Not a C# programmer...but could you Shell to something like:

c:\myFolder\myAccessDatabase.mdb /compact

This as you can see uses the command line switch /compact.

Upvotes: 1

Foole
Foole

Reputation: 4850

I would use Jet Replication Objects (JRO). For example code, see here.

Upvotes: 1

Kevin Ross
Kevin Ross

Reputation: 7215

The easiest way is going to be by using the standalone program “JetComp.exe” and just calling that from your c# code

http://download.microsoft.com/download/access2000/utility/1.0/win98me/en-us/jetcu40.exe

Another option would be to open a DAO connection to the database and use the .CompactDatabase method. Not being a c# bod I cant really offer a code sample but it is quite easy to do in VBA, for that reason I would just use the first option

Upvotes: 3

Related Questions