Upgrading to SQL Server 2005 while maintaining .adp access

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?

    Requires Free Membership to View

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 first published in July 2006

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.