Hi all
I want Compact a Access DataBase File in C# by Code. please Help me
Edited: I USe Microsoft Access 2007 DataBase File
+3
A:
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
Kevin Ross
2010-02-08 08:15:20
I wouldn't recommend JetComp.exe, as it's going to do things beyond what the native Jet CompactDatabase methods will do. That is, you could lose data if the file is damaged. The DAO and JRO CompactDatabase methods will crap out in cases where JetComp will go ahead and try to fix things. I'd keep JetComp as backup for the rare case when the standard DAO/JRO CompactDatabase method errors out because of a damaged file.
David-W-Fenton
2010-02-09 02:16:15
+1
A:
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.
maxhugen
2010-02-09 05:35:15
It's much better to do this kind of thing directly with the data interface libraries that talk to the db engine itself. And your suggestion would require that Access be installed.
David-W-Fenton
2010-02-09 22:02:38