Jim Dettman
jimdettman at earthlink.net
Wed Sep 22 09:27:01 CDT 2004
If I'm not mistaken, Martin alluded to this some time ago, basically making the statement that the Access world was going to have a serious departure from SQL within the next version or two and there would be a lot of unhappy folks. Looks like its about to happen. Jim (315) 699-3443 jimdettman at earthlink.net -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of MartyConnelly Sent: Tuesday, September 21, 2004 5:50 PM To: Access Developers discussion and problem solving Subject: [AccessD] ADPs in the future Just in passing concerning future design about ADP's from Access 2003 on down that will not play fair with SQL Server 2005 Express (replacement for MSDE). Re: Access 2002 and SQL Express From: "Mary Chipman [MSFT]" <mchip at online.microsoft.com> Sent: 8/20/2004 11:30:58 AM You will not be able to use any of the designers with SQLS 2005 databases, whether it's SQL Express or the Developer edition. IOW, you won't be able to create databases, tables, views or any other database objects from an ADP. The only support that is envisioned is that you will be able to connect an Access front-end to a SQLS 2005 back end if it is running in SQLS 2000 compatibility mode, so your forms, reports and other local Access objects should still run. There is no service pack or quick fix being planned as far as I know because of the amount of work it would entail. If you stop to think about it, it's pretty hard to see how accomodating new Yukon features like CLR assemblies and complex data types in the ADP designers could be achieved without a complete rewrite. --Mary Chipman -- Marty Connelly Victoria, B.C. Canada -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com