Access 2003 & SQL Server 2005

N

Neil

We have an Access 2000 MDB with a SQL 7 back end. We are upgrading SQL
Server to SQL 2005, and are considering upgrading to Access 2003. Someone
mentioned that they had heard about some incompatibilities between Access
2003 and SQL Server 2005. Anyone hear of anything? And, if so, would staying
with Access 2000 be better?

Thanks!

Neil
 
N

Norman Yuan

I guess the said "incompatibilities" were referred to MS Access ADP. If you
use Access MDB to link to SQL Server2005, then there is not much difference
between Access2003 and Access2000/2002 (obviously, Access2003 is supposed to
be a bit better than 2000/2002).
 
N

Neil

Thanks for that. Do you know, specifically, in what ways A2003 is supposed
to be better than 2000/2002 when linking to SQL Server?

Thanks.
 
N

Norman Yuan

Sorry, I do not use Access that much after Access2K, so cann't tell the
differences (of advantages) of later version of Access.
 
N

Neil

I just meant what you meant when you wrote: "obviously, Access2003 is
supposed to be a bit better than 2000/2002"

Thanks!

Neil
 

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

Reaching Access 2003 datas via SQL Server 2005 64 bits 2
Access 2003 or 2007 Compatible with SQL Server 2008 6
Access 2003 Project connecting to SQL 2005 2
Access 2000 ADP and SQL Server 2005 2
Sql Server 2005 Express Advanced Services 1
Sort date by Desc doesn't work in SQL Server 2005 2
Linking tables access - sql server 2005 4
Upgrading Access databases to SQL 2005 Exp 1

Top