Jeff,
Okay, THANKS. Got part of it working... at least the linked server shows up... I can't query it, but I can see it. =) (About as much fun as the cookie jar that you can't reach!)
Here's all the code I ran...
sp_configure 'show advanced options', 1;
RECONFIGURE;
sp_configure 'Ad Hoc Distributed Queries', 1;
RECONFIGURE;
GO
SELECT TOP 5 *
FROM OPENROWSET(
'Microsoft.ACE.OLEDB.12.0',
'C:\Users\Pieter\Desktop\ColliePowerPivot\BookData.accdb';
'';'',
DimDate
) acc
When I run the query, I get:
OLE DB provider "Microsoft.ACE.OLEDB.12.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.ACE.OLEDB.12.0" for linked server "(null)"
.
I'm kinda waiting for the sirens to go off... "Access Denied!! SQL Knucklehead detected!"
Uncle! I give for now.
Pieter