Hi,

I was wondering if anyone could help me on the following error message:

Failed to export data to Excel file. Ad hoc access to OLE DB provider 'Microsoft.Jet.OLEDB.4.0' has been denied. You must access this provider through a linked server.



I am using a Web Application, when I try to export the data to excel I receive the above error message. Both the application and database are on my local machine-I am trying to set the application up, so it hasnt worked before.


I have tried the following "solution" but no luck

http://www.issociate.de/board/goto/5...r_through.html


Any thoughts would be much appreciated


Thanks