Michael, The author is mixing apples and oranges and misses the main point; Access makes an excellent front end tool for SQL Server and a variety of other RDBMS. Also, until 2007, you had a native interface to SQL Server built-in (most developers I know have virtually ignored 2007). Even without that interface, you can still connect to almost any backend using ODBC or OLEDB, which makes it easy to do heterogeneous joins across different back ends. And it wasn't until the current version of SQL and VS that you had some tools comparable to what you'd find in Access.
As far as the use of JET as a database engine and why one might continue to use it is the fact that modifications have been made to give some very tight integration with Share Point Services, which don't exist in SQL Server. Plans are also being made to extend the JET engine (it is now in the control of the Office team). I would agree that for the typical desktop application, the use of SQL Server 2005 Express is almost a given over a JET database, but it still means some additional overhead (ie. separate backup cycle) and using it certainly doesn't preclude the use of Access as a front end. I see no reason in the world to get rid of it. Heck, you could make the same argument with VFP and DBF's for that matter. Jim. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MB Software Solutions Sent: Thursday, August 09, 2007 3:29 PM To: [EMAIL PROTECTED] Subject: [NF] When Will MS Kill Access? -- Die Access Die!] Good article posted by Carl on VFUG. Die Access Die! The guy makes some good points...why not just use SQL Server instead of Access, especially since the Express version is free anyway and provides an easier migration path?? -------- Original Message -------- >From the VFUG.Org List Server: Database Underground | InfoWorld | Die Access Die! | August 8, 2007 06:35 AM | By Sean McCown: http://weblog.infoworld.com/dbunderground/archives/2007/08/die_access_die.ht ml?source=rss -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com "Work smarter, not harder, with MBSS custom software solutions!" No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.476 / Virus Database: 269.11.6/938 - Release Date: 8/5/2007 4:16 PM --- StripMime Report -- processed MIME parts --- multipart/mixed text/plain (text body -- kept) text/plain (text body -- kept) --- [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
