Well since CFMX Access really is a no go now because if anyone overloads their access db, it will kill JDBC and ColdFusion will hang and everyone on the same server will be stuffed. It's an official warning from MM now, don't use Access in a live environment. So you just have to hope other customers on the same server as you don't write rubbish code and try and use Access beyond it's limits. Not particularly nice...
Needless to say, were now looking at providing MySQL as the free/cheap alternative to Access. We are also going to the point of having two sets of servers. The reliable/secure servers, where there is no access databases, no enterprise manager access to SQL server, no insecure tags, no custom components, clients must have properly tested apps, no developing or testing of code on live server etc. The At your own risk servers, running Access, Enterprise manager, custom components CFX tags etc, and customers can do whatever they want here. Russ > -----Original Message----- > From: Ellwood [mailto:[EMAIL PROTECTED] > Sent: 02 July 2004 16:20 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] SQL compared to Access backend > > Severe limitations when you want to push the boundaries but I > certainly DO NOT advocate recommending that my clients switch > from Access to SQL Server just because it can do stored procs > and triggers and views(which are the same as queries in > Access). There is no doubt in anybodies mind that SQL Server > is far superior but my point is simple "horses for courses". > > Ellis C Wood BSc > > Ellwood Web Solutions > > > > T: 01623 459973 > > E: [EMAIL PROTECTED] > > W: http://www.ellwoodwebsolutions.co.uk > > > -----Original Message----- > From: Robertson-Ravo, Neil (RX) > [mailto:[EMAIL PROTECTED] > Sent: 02 July 2004 09:12 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] SQL compared to Access backend > > This is certainly not true.... Access is a desktop database > with sever limitation in comparison to its larger brother in > the Microsoft camp....Stored Procedures you have mentioned > but what about Triggers, Views, superior backup / disaster > recovery, Transactions, better logging, UDF's, greater number > of SQL commands available., far far greater > performance....Access cannot even be compared to SQL Server > when it comes to that, it will win hands down. > > Access also has sever limitations when it comes to file size > and available options in the tables itself such as bytes per > row, database size and object size. > > > > > > > > > > -----Original Message----- > From: Ellwood [mailto:[EMAIL PROTECTED] > Sent: 01 July 2004 22:21 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] SQL compared to Access backend > > Other than database performance (which in my my experience is > not too greatly different in either) the only real > improvement between sql and access is stored procs (which are great). > > Ellis C Wood BSc > > Ellwood Web Solutions > > > > T: 01623 459973 > > E: [EMAIL PROTECTED] > > W: http://www.ellwoodwebsolutions.co.uk > > > -----Original Message----- > From: Jolly Green Giant [mailto:[EMAIL PROTECTED] > Sent: 01 July 2004 01:40 > To: [EMAIL PROTECTED] > Subject: [ cf-dev ] SQL compared to Access backend > > So how different is your code when your backend is SQL Server > rather than Access? I've worked in Access for 4 years. What > can I expect to be different if I want to work in SQL? Most > simple queries will stay the same, won't they? > > I know some functions may change, but what else? > > Thanks! > > David /jgg > > > -- > These lists are syncronised with the CFDeveloper forum at > http://forum.cfdeveloper.co.uk/ > Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > CFDeveloper Sponsors and contributors:- > *Hosting and support provided by CFMXhosting.co.uk* :: > *ActivePDF provided by activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow provided by > proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists hosted by > gradwell.com* > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > -- > These lists are syncronised with the CFDeveloper forum at > http://forum.cfdeveloper.co.uk/ > Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > CFDeveloper Sponsors and contributors:- > *Hosting and support provided by CFMXhosting.co.uk* :: > *ActivePDF provided by activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow provided by > proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists hosted by > gradwell.com* > > To unsubscribe, e-mail: [EMAIL PROTECTED] > This e-mail is from Reed Exhibitions (Oriel House, 26 The > Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a > division of Reed Business, Registered in England, Number > 678540. It contains information which is confidential and > may also be privileged. It is for the exclusive use of the > intended recipient(s). If you are not the intended > recipient(s) please note that any form of distribution, > copying or use of this communication or the information in it > is strictly prohibited and may be unlawful. If you have > received this communication in error please return it to the > sender or call our switchboard on +44 (0) 20 89107910. The > opinions expressed within this communication are not > necessarily those expressed by Reed Exhibitions. > Visit our website at http://www.reedexpo.com > > -- > These lists are syncronised with the CFDeveloper forum at > http://forum.cfdeveloper.co.uk/ > Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > CFDeveloper Sponsors and contributors:- > *Hosting and support provided by CFMXhosting.co.uk* :: > *ActivePDF provided by activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow provided by > proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists hosted by > gradwell.com* > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > -- > These lists are syncronised with the CFDeveloper forum at > http://forum.cfdeveloper.co.uk/ > Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > CFDeveloper Sponsors and contributors:- > *Hosting and support provided by CFMXhosting.co.uk* :: > *ActivePDF provided by activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow > provided by proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists > hosted by gradwell.com* > > To unsubscribe, e-mail: [EMAIL PROTECTED] > -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
