ADPs and SQL Server 2005

D

dotNetNewbie

We are considering the pros and cons of upgrading from SQL Server 2000 to SQL
Server 2005. We have several applications that are ADPs and have heard that
SQL Server 2005 does not support ADPs. Can anyone direct me to some hard
facts about ADP and SQL Server 2005? I can find no mention of ADPS wrt 2005
on the MS web site, but I'm probably just not searching through the right
path!
 
L

Lolik

Access 2003 .APDs developed with SQL Server 2000 work fine with SQL Server 2005

You can't change design of '05 database objects in Access 2003 but you can
work on them in SQL Server Management Studio Express which is as good (or
better than) as Access 2003.

You can still design Forms, Reports and Modules in Access 2003.

I'd suggest to go ahead and upgrade.
 
Top