[AccessD] ADPs in the future

Dan Waters dwaters at usinternet.com
Wed Sep 22 08:18:46 CDT 2004


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




More information about the AccessD mailing list