Does access 2003 support sql server 2005 connections?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We have an .ADP connected to SQL Server 2000 and are considering upgrading to
SS2005.
 
In a word, Yes.
Access 2003 .adp files work without problems with databases previously
created on MSDE 2000 upgraded to SQL Server 2005.

You can't design tables, procedures etc in Access 2003, but you can do all
that (much as you did with Access2003 / MSDE 2000) in SQL Server Management
Studio Express.

Make sure you install SQL Server 2005 with Advanced services!
 
You must log in or register to reply here.

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

using access 2003 adp with sql server 2005 2
how do I create an adp in access 2010 2
ADO 1
Vista and SQL server 2005 problem 4
What are the steps to fix damaged MDF files in SQL Server? 0
Does Microsoft recommend databases or projects to connect to SQL s 1
Access 2000 ADP and SQL Server 2005 2
ADO vs ADP 1

Back
Top