Dear All,

I am creating the linked server to Ms access database to Ms Access using the Ms JET 4.0  OLE DB Provided. It was working fine in SQL 2000. With SQL 2005 launched, we are now using the 2005 and created the same. This setting is really making me crazy as it keep on prompted me the below message: 

OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Unspecified error".

Msg 7303, Level 16, State 1, Line 1

Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".

 We are using Windows server 2008 now. It was working fine earlier. But recently there are some Windows update and the message appeared without us changing any setting on the Linked server.

I have search through the web but it seem like there is no helps for me.

Please HELP!