Compacting Access Database

[sjn78]

Has anyone compacted an access database through an app? I have looked around for ages and havent come across a method that will do it.

VB6 use to do it and I guess .NET should too.

If anyone knows, could you put up a sample for me.

Thanks

 

[Derek Stone]

There is no direct support for this in ADO.NET. Either use ADO or upgrade to a more robust database.

 

[sjn78]

Thanks for that. I will have to look for an alternative method.

 

[mrdutchie]

This is how you do this


sPath = "c:"
If Dir(sPath & "\Temp.mdb") > "" Then Kill(sPath & "\Temp.mdb")
CompactDatabase(workfile, JetEngineTypes.JetCompatible, True) , "c:\Temp.mdb")