I get the following error message when attempting to export items from the list. I can view all of the records and search everything fine, just cannot export. I am running IIS on my local computer and accessing an Access database on my local computer. Any help would be greatly appreciated.
The page cannot be displayed
There is a problem with the page you are trying to reach and it cannot be displayed.
--------------------------------------------------------------------------------
Please try the following:
Click the Refresh button, or try again later.
Open the home page, and then look for links to the information you want.
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
--------------------------------------------------------------------------------
Technical Information (for support personnel)
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.
/unitdirectory/include/commonfunctions.asp, line 6087
Browser Type:
Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; InfoPath.1)
Page:
GET /unitdirectory/Web_Master_export.asp
Time:
Wednesday, December 13, 2006, 4:11:39 PM
More information:
Microsoft Support