Charlotte Foust
cfoust at infostatsystems.com
Wed Sep 22 10:37:18 CDT 2004
Access 2003 is designed to work with SQL Server 2000, not the next version of SQL Server. Charlotte Foust -----Original Message----- From: Dan Waters [mailto:dwaters at usinternet.com] Sent: Wednesday, September 22, 2004 6:19 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] ADPs in the future Hello to All, Well, I am now confused. I have read that Access 2003, as an ADP, includes a builder for stored procedures. Why would MS add this feature to a product if it can't be used? There has to be more to this story. Dan Waters -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: Wednesday, September 22, 2004 4:47 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] ADPs in the future Hi Marty Though I haven't played with the "Express" versions, this sounds interesting. I have, however, no idea why "CLR assemblies and complex data types" would require a complete rewrite, so could you please spell out for SQL 2005 dummies like me, what this message means? What I read is that an Access ADP cannot - and will not be able to - work with SQL 2005 ... I guess "SQLS 2000 compatibility mode" is not something you can turn on and off but something you choose at installation time. /gustav > 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 -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com