You should not start Access on the server just to compact a database (well, you should never have any reason to start Access on the server).
To compact a database you can use JRO (a com object include with MDAC). I wrote a custom tag to do this, but haven't tested it under CFMX: http://devex.macromedia.com/developer/gallery/info.cfm?ID=09DD4B36-6397- 11D6-840300508B94F380&method=Full > -----Original Message----- > From: Joshua Miller [mailto:[EMAIL PROTECTED]] > Sent: Thursday, January 16, 2003 5:24 PM > To: CF-Talk > Subject: RE: Alternatives to MS Access (WAS Re: MS Access) > > > Something to consider when using Access is the Compact and > Repair utility - you can programmatically invoke that process > on a database provided your server has Access installed. > There's some info on CFComet (which I couldn't get to work) > so I wrote one in ASP (spit) that invokes the Compact and > Repair function on a database. It's a real PITA when you have > to download, modify and upload a database but it's grown to > 15MB even though there are only 10 records in it :) > > If you're interested email me off-list and I'll send a copy > of the ASP script. > > BTW: I've used MSDE with success a couple of times - it's > actually a pretty good product. > > Thanks, > > Joshua Miller > Head Programmer / IT Manager > Garrison Enterprises Inc. > www.garrisonenterprises.net [EMAIL PROTECTED] > (704) 569-9044 ext. 254 > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
