ADPs and SQL Server 2005

G

Guest

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!
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2000 ADP and SQL Server 2005 2
SQL Server 2005 schema for Access 2007 ADP 2
Looking for experiences using .adp projects over SQL Server 2005 3
SQL Server tables in Access 2007 are read-only via ADP ! 5
ADP and SQL 2005 2
Is adp or mdb better SQL Server 2005 front end? 6
Not able to create new tables/queries in .adp 4
Using Access 2007 adp project files with SQL Server 2008 Express 3

Top