SQL Server and Access 2003 or Access 2007

We currently are using Access 2003 and SQL Server 2000. We plan to upgrade
our SQL Server to 2008. Our biggest concern is the Compatibility issues with
access. Ideally we would like to stay on Access 2003, but what little
research I have done, it does not look like Access 2003 is compatible with
SQL Server 2008. The next step would be for us to upgrade Access 2003 to 2007
and use it with SQL Server 2008. I have done a little research on this and
again it does not look like they are real compatible. I have read Access 2003
is compatible with SQL Server 2005, but it would be a real shame if we could
not upgrade to SQL Server 2008 because of Access. Does anyone know if Access
2003 is Compatible with SQL Server 2008 or if Access 2007 is compatible with
SQL Server 2008.

thanks
Toni

Yes, Access 2003 is compatible with SQL Server 2008, within limits.
Bear in mind that SQLS 2008 has data types (among other features) that
did not exist when Access 2003 was released, which will give you a
good idea of what works and what doesn't. Here's a whole slew of
resources. --Mary

TechEd Online Panel (video):
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.aspfaq.com/what-are-the-main-difference...etween-

"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

Migration Considerations for Access 2007
http://technet.microsoft.com/en-us/library/cc178973.aspx

On Wed, 19 Nov 2008 10:04:06 -0800, Toni
wrote:

>We currently are using Access 2003 and SQL Server 2000. We plan to upgrade
>our SQL Server to 2008. Our biggest concern is the Compatibility issues with
>access. Ideally we would like to stay on Access 2003, but what little
>research I have done, it does not look like Access 2003 is compatible with
>SQL Server 2008. The next step would be for us to upgrade Access 2003 to 2007
>and use it with SQL Server 2008. I have done a little research on this and
>again it does not look like they are real compatible. I have read Access 2003
>is compatible with SQL Server 2005, but it would be a real shame if we could
>not upgrade to SQL Server 2008 because of Access. Does anyone know if Access
>2003 is Compatible with SQL Server 2008 or if Access 2007 is compatible with
>SQL Server 2008.
>
>thanks
>Toni