QUESTION POSED ON: 29 June 2006 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?
>
EXPERT RESPONSE
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.
Search and Browse the Expert Answer Center Search and browse more than 25,000 question and
answer pairs from more than 250 TechTarget industry experts.
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.
