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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
