Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_databases thread: access asp date compare


Message #1 by "Greg L Robillard" <grob1@o...> on Mon, 26 Aug 2002 16:44:22
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.


				

  Return to Index