I have read several books on SQL Server.

I would recommend that a newbie reads books in the following order -

1. Starter - Murach's SQL Server 2008 for developers.

2. Refresher -...

In SQL Server, go to Providers object, right click on Microsoft.ACE.OLEDB.12.0 and select properties, then put a check on Allow inprocess.

i tried the select command mentioned by you. my version is -

9.00.3042

However, i am still unable to connect to Access 2007 accdb. The error message is -

Msg 7399, Level 16,...

i'm using sql server 2005 express which i recently downloaded, so i guess it already has sp2 or whatever..(i havnt separately downloaded sp2)

However, I did everything else that you mentioned...

Hi, did u find out how to create a linked server to access 2007 accdb file? If so, pls mail me the syntax. Thanks.