SQL Server and Access 2003 or Access 2007

SQL Server and Access 2003 or Access 2007

Post by VG9ua » Fri, 21 Nov 2008 03:04:06


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
 
 
 

SQL Server and Access 2003 or Access 2007

Post by Mary Chipm » Sat, 22 Nov 2008 02:23:26

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://www.yqcomputer.com/
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.yqcomputer.com/

Optimizing Microsoft Office Access Applications Linked to SQL Server
http://www.yqcomputer.com/

What are the main differences between Access and SQL Server?
http://www.yqcomputer.com/

"The Best of Both Worlds--Access MDBs and SQL Server"
http://www.yqcomputer.com/

SQL Server Migration Assistant for Access (SSMA for Access)
http://www.yqcomputer.com/

FMS Upsizing Center
http://www.yqcomputer.com/

Microsoft Access Developer's Guide to SQL Server
http://www.yqcomputer.com/

Migration Considerations for Access 2007
http://www.yqcomputer.com/

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