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]
