[AccessD] Access and Vista

Just came across this for those of you planning down the road .

Yes it's true: MSDE 1.0 and 2000 will not be supported on Windows Vista

http://blogs.msdn.com/sqlexpress/default.aspx

What about Access 2003?

Access 2003 already supports using SQL Express, no patching required. 
There are a couple known issues when paring these two products:

·  The SQL designers in Access 2003 do not work against SQL 2005. This 
is true for Access, Visual Studio 2003 and any other product that uses 
the VS designers from the 2003 product line. You can still use the text 
based designers in Access 2003 or you can use Management Studio Express, 
which can be downloaded free of charge from the download link above.

·  Access 2003 does not understand the new User-Schema separation 
implemented in SQL Server 2005. Databases migrated from SQL Server 2000 
to SQL Server 2005 will still work as expected. You should have no 
problems working with new database in SQL Server 2005 as long as you 
don't use User-Schema separation.

·  Access 2003 doesn't know about the new SQL Server 2005 data types. In 
my experience, the new types are shown as Memo when part of a Linked Table

Access 2007 has been updated to address these issues.

-- 
Marty Connelly
Victoria, B.C.
Canada