ADP and SQL 2005

G

Guest

I have an ADP that works fine under SQL 2000. I can do File > Connection and
switch between servers and/or databases and it never gives me a problem.

I took my ADP over to a server with SQL 2005 and any attempt to do File >
Connection does not refresh the table and queries list. In fact, if I try to
create a new table or query (stored procedure or view), it tells me that
there is no connection set for the ADP. This despite the fact that I just
tested the connection under File > Connection and it worked fine!

If anyone knows the cause of this I'd sure appreciate hearing from you.

Thanks, Herb
 
S

Sylvain Lafontaine

For editing tables/views/stored procedures in SQL-2005, you must use ADP
2007 or SQL-Server Management Studio.

Previous versions of ADP (2000/2/3) can't be used to make design work
against SQL-2005 but can be used for inserting/editing/deleting the data.
 

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

Call stored procedure in SSMS from Access 2016 doesn't work. 0
ADP connection to SQL 2005 Standard SP2 4
Access 2000 ADP and SQL Server 2005 2
Access 2007 and ADP to SQL Server 2005 in Vista 12
Using mirrored sql 2005 db with a ms access adp project 1
Can't connect to local SQL Server 2005 from .adp 7
Queries missing in ADP and SQL after upsizing 4
ADP Error opening tables on SQL SERVER 2005 and Access 2007 5

Top