2. ASPRunnerPro General questions
  3. Another error '80040e14'
This topic is locked

Another error '80040e14'

 		9/20/2006 11:16:28
ASPRunnerPro General questions
A
 ashumak author

Added a field for Name and email address. The email address is dependent

on the monexrep name...when I enter a name and the email address auto fills, when I go back to the list, it shows this error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '[MonexRep] = Alan Shumak and 1=1'.
/teleleads/Shipping_list.asp, line 1720
As always...HELP....
Alan
Sergey Kornilov admin 9/20/2006

Alan,
could you tell me why when you get back from the Edit page data becomes filtered?

What are other application option that are in use (security modes etc)?
A
 		ashumak author 9/21/2006

Query finishes with

WHERE ((dateclosed)=#01/01/2001#)
And Group Permissions are

Users can see and edit thier own data only
Does that help?
Alan
Sergey Kornilov admin 9/21/2006

No, it doesn't help.
Zip and send me your files along with step-by-step guide on reproducing it.
A
 		ashumak author 9/22/2006

O.K. so maybe I should look closer at my typing. The field fopr email was incorrect...it's now working fine. Thanks for the offer of assistance though.
Alan