sjn78 Posted September 7, 2003 Posted September 7, 2003 Has anyone compacted an access database through an app? I have looked around for ages and haven't 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 Quote
*Gurus* Derek Stone Posted September 7, 2003 *Gurus* Posted September 7, 2003 There is no direct support for this in ADO.NET. Either use ADO or upgrade to a more robust database. Quote Posting Guidelines
sjn78 Posted September 8, 2003 Author Posted September 8, 2003 Thanks for that. I will have to look for an alternative method. Quote
mrdutchie Posted September 8, 2003 Posted September 8, 2003 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") Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.