Hi,
I'm trying to create a link to an Access database in SQL Server 2005
Express. I can do this through Management Studio so it is showing under

the 'Linked Servers' branch on the left hand side, however it does not
show any of the MDB file's tables, or anything for that matter.

I've tried this using the wizard-type approach and using the stored
procedure (sp_linkserver?), either way the server is added, but the
icon associated with it is greyed out and has no features.


Any help greatly appreciated.
Thanks
Adam

can you run the utility named 'SQL Server Surface Area Configuration'
and check to make sure that lnked server/openrowset and all that jazz
is enabled??