Link to SQL Server 2005

[SHIPP]

My company is looking at setting up a SQL Server 2005 database. Can I link to
it from Access 2003 without a problem?

 

[Rick Brandt]

My company is looking at setting up a SQL Server 2005 database. Can I
link to it from Access 2003 without a problem?

Yep. You could also do so from Access 2002, 2000, and 97.

 

[Mary Chipman [MSFT]]

As Rich said, you can link to it from different versions of Access.
However, bear in mind that there isn't 100% compatibility between the
two when it comes to things like data types. You'll want to do some
research first to find out the most appropriate use cases for your
particular business scenarios. Here's a list of resources you might
find useful.

--Mary

TechEd Online Panel:
Go to http://msdn.microsoft.com/en-us/events/teched/cc676818.aspx and
search for:
"Are we there yet? Successfully navigating the bumpy road from Access
to SQL Server"

Microsoft Access or SQL Server 2005: What's Right in Your
Organization?
http://www.microsoft.com/sql/solutions/migration/access/sql-or-access.mspx

Optimizing Microsoft Office Access Applications Linked to SQL Server
http://msdn.microsoft.com/en-us/library/bb188204.aspx

What are the main differences between Access and SQL Server?
http://sqlserver2000.databases.aspf...ifferences-between-access-and-sql-server.html

"The Best of Both Worlds--Access MDBs and SQL Server"
http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp

SQL Server Migration Assistant for Access (SSMA for Access)
http://www.microsoft.com/sql/solutions/migration/access/default.mspx

FMS Upsizing Center
http://www.fmsinc.com/Consulting/sqlupsizedocs.aspx

Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/dp/0672319446