Could not create an instance of OLE DB provider 'Microsoft.Jet.OLE

hi,
I am running the following query and getting this error.
Could not create an instance of OLE DB provider 'Microsoft.Jet.OLEDB.4.0'.
OLE DB error trace [Non-interface error: CoCreate of DSO for
Microsoft.Jet.OLEDB.4.0 returned 0x80040e73].
I am using Windows XP SP2 and Access 2003 and running this query on a SQL
server 200 which is on a network.
SELECT *
FROM OPENdatasource(
'Microsoft.Jet.OLEDB.4.0',
'Data Source="\\machineNameOnNetwork\c:\Test.mdb;"
User ID=admin;Password=somePassword;"'
).Test.dbo.Employees
Thanks
Regards,
tech@.77A shot in the dark: the UNC path you're specifying doesn't look quite normal
.
Did you mean
\\machineNameOnNetwork\c$\Test.mdb
?
"tech77" wrote:

> hi,
> I am running the following query and getting this error.
> Could not create an instance of OLE DB provider 'Microsoft.Jet.OLEDB.4.0'.
> OLE DB error trace [Non-interface error: CoCreate of DSO for
> Microsoft.Jet.OLEDB.4.0 returned 0x80040e73].
> I am using Windows XP SP2 and Access 2003 and running this query on a SQL
> server 200 which is on a network.
> SELECT *
> FROM OPENdatasource(
> 'Microsoft.Jet.OLEDB.4.0',
> 'Data Source="\\machineNameOnNetwork\c:\Test.mdb;"
> User ID=admin;Password=somePassword;"'
> ).Test.dbo.Employees
> Thanks
> Regards,
> tech@.77|||A few pointers. Don't know whcih one is applicable for you though
1. If you are accessing a network share ,then the account in which SQL
Server is running should have access to that share.
2. Do not use C:, use C$ like this..
\\machineNameOnNetwork\c$\Test.mdb;"
Hope this helps.