[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