access and openrowset

[junkmail]

Can someone tell me why this does not work?

SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','C:\work\database1.accdb;','select * from [table1]')

this is a error I get.

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

 

[pjw001]

Try this

This works for me:
SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'C:\work\dbname.mdb'; 'admin';'',TranHdrs)

This was on SQL 2005 and an oldish version of Access.