sql server msde: Does SQL SERVER 2005 Express provide support for use as a backend database

hi,
[quoted text, click to view]

I'm not an Access guy, but I've been told you can use SQL Server 2005 as
backend for Access 2003 and XP... you shold not rely to much on the Access
"designer" for objects definition as SQL Server 2005 changed a lot of things
in the metadata structure, but you can "use" it..
as regard Access 2000 I personally did not try.. perhaps asking in Office
related ng can give better answers..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
--------- remove DMO to reply

Create an ODBC connection to your SQL Server 2005 database - I am not
familiar with the Express version. Then use the ODBC Connecton to create
linked tables in Access to whatever tables are in your database.

[quoted text, click to view]