Manage Learn to apply best practices and optimize your operations.

Upgrading to SQL Server 2005 while maintaining .adp access

Maintaining .adp access while uprgrading to SQL Server 2005 could be a problem. SQL Server 2005 expert Adam Machanic advises on a course of action to take.

We have SQL Server 2000 with many .adp serving our group. We're going to upgrade to SQL Server 2005 and need to know the timing for that. Will SQL Server 2005 support the Acess .adp and Data Access pages we have out there or will we have to reprogram everything for SQL Server 2005?
Based on this thread from the MSDN forums Problem to connect Access 2003 to SQL Server 2005 Express it appears that you may have a problem. You should probably test on your end in order to verify the issue and start determining what course of action (if any) to take.
This was last published in July 2006

Dig Deeper on SQL Server Migration Strategies and Planning

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.