EXCELLENT! I'm going to download it and test it on CFMX right now - I'd love to be able to take Access OFF of our server !!!
Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-9044 ext. 254 ************************************************************************ ************* Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to [EMAIL PROTECTED] ************************************************************************ ************* -----Original Message----- From: Samuel Neff [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 16, 2003 6:55 PM To: CF-Talk Subject: RE: Alternatives to MS Access (WAS Re: MS Access) 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
