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 ************************************************************************ ************* 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: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 16, 2003 4:51 PM To: CF-Talk Subject: Alternatives to MS Access (WAS Re: MS Access) Lots of back and forth about Access vs MySQL on this thread -- but I'm surprised noone suggested MSDE. You can use all the SQL Server tools, you can easily (relatively) upgrade to SQL Server when/if the time comes. The price is right. You can point Access at it to manage from a familiar UI. So if the issue is "we can't afford MS-SQL but wish we could" then you've got a good argument for using MSDE. If this is more "we *only will consider* Access", then you're screwed. On the plus side, you can keep maintenance on an hourly rate and buy a Mercedes in a year :) Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] ----- Original Message ----- From: "Robert Bailey" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, January 16, 2003 11:21 AM Subject: RE: MS Access > Sometimes you really have to go with what they want, and what they > desire it to be built on. I have already suggested using SQL, but they > insist on using Access, so I can either turn it down or just go ahead > and do it. The reason why they want to use Access is because the > current app is running on Access and they do not seem to understand > that the upgrade would take no time. Also, it is not going to be a > high volume app, just quite a few tables. Again, who am I complain as > long as I get paid > > > Robert Bailey > [EMAIL PROTECTED] > "Famous for nothing!" > http://www.tinetics.com > > > > > -----Original Message----- > From: Robertson-Ravo, Neil (RX) > [mailto:[EMAIL PROTECTED]] > Sent: Thursday, January 16, 2003 8:12 AM > To: CF-Talk > Subject: RE: MS Access > > > Erm, if its a big project you sure as hell dont want to be doing it in > Access - its a Desktop application. You should stick with MS SQL > Server - > its far more robust and is Enterprise level! > > -----Original Message----- > From: Robert Bailey [mailto:[EMAIL PROTECTED]] > Sent: 16 January 2003 16:10 > To: CF-Talk > Subject: MS Access > > > Being that I have mostly developed apps on MS SQL or Sybase, I am > getting ready to embark an quite a large application using MS Access. > My question is this, can you use joins at all in Access? I have > written quite a few access apps, but nothing complicated enough to > need any joins in the SQL. Thanks! > > > Robert Bailey > [EMAIL PROTECTED] > "Famous for nothing!" > http://www.tinetics.com > > > --- > [This E-mail scanned for viruses] > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
