asp_databases thread: access asp date compare
I am running the script below. strsql="SELECT * FROM InputRecords WHERE EmployeeName='"&strName&"' AND RecordDate>=#"&strMonth&"# AND RecordDate<=#"&strEndMonth&"# AND HCode IS NULL AND GCode IS NULL ORDER BY PCCode, RecordDate" The problem is, it works fine an several systems that I have tested it on, but I receive the following error on the clients computer. Microsoft JET Database Engine error '80040e14' Internal OLE Automation error Any clues.
|





