SQL 2008 upgrade

[Sam]

I am upgrading my backend from SQL 2000 to SQL 2008 with MSAccess 2003 as
frontend. So far testing has not identified any MS Access issues with the
conversion. Is anyone aware of any specific issues with MS Access? Things I
should look at or test?

Thanks,
Sam

[Mary Chipman [MSFT]]

It's difficult to say without knowing more about your Access
application, but here's a couple of good resources for you to check
out:

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-differences-between-access-and-sql-server.html

--Mary

On Thu, 15 Oct 2009 08:39:35 -0700, Sam

Post by Sam
I am upgrading my backend from SQL 2000 to SQL 2008 with MSAccess 2003 as
frontend. So far testing has not identified any MS Access issues with the
conversion. Is anyone aware of any specific issues with MS Access? Things I
should look at or test?
Thanks,
Sam

[Tony Toews [MVP]]

Post by Sam
I am upgrading my backend from SQL 2000 to SQL 2008 with MSAccess 2003 as
frontend. So far testing has not identified any MS Access issues with the
conversion. Is anyone aware of any specific issues with MS Access? Things I
should look at or test?

Several people have had troubles with the Merge Replication
functionality in SQL Server 2008 and Access. As always YMMV.

Tony