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


Any thoughts would be much appreciated