method refresh of object Iadodc failed 1

[ezroberts]

I get this error on the adodc1.refresh code line. I am using Access Database. Here is the revelant code:

asql = &quot;select * from messages where sendto = '&quot; & imuser & &quot;' and read <> 0&quot;
imclient.Adodc1.CommandType = adCmdText
imclient.Adodc1.ConnectionString = &quot;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=&quot; & datapath & &quot;;Persist Security Info=False&quot;
imclient.Adodc1.RecordSource = asql
imclient.Adodc1.Refresh

The same control is also used for a different sql statement in the forms load property. It works fine. If I delete tha and clause from the above code, the form works fine. Any suggestions would be greatly appreciated.

 

[LazyMe]

Maybe read is a keyword and should be [read].
Greetings,
Rick