Hi again

The problem is now solved. It had to do with the account on the server that the SQL Server Service runs under. I changed it from Network Service to...

Hi Sugesh! Thank you for the reply.

I tried you suggestion without any luck. I still get this error when querying logged on as a domain user:

OLE DB provider "Microsoft.Jet.OLEDB.4.0" for...