error '80004005'

[mdr227]

I am doing a selection from an access db based on a simple SQL statement that was always working fine, but now I am getting this error '80004005' message on the statement

"set rs1=conn.execute("select * from tblCalendar where zone='East'")

If I remove the where clause it works OK or if I change the where clause to have criteria in a different field it works OK. I copy that statement to the access db and run it and it works OK. Does anyone know what could be causing this to error out in ASP all of the sudden?

 

[Veep]

Are those quotes before the SET keyword also in your code?

[red][b]"[/b][/red]set rs1=conn.execute("select * from tblCalendar where zone='East'")

 

[DreXor]

try [zone] instead ( just encasing the field name ) access can be a bit stingy about alot of "keyish" words.

 

[Veep]

That was my first though but I look them up:

http://support.microsoft.com/defaul...port/kb/articles/Q109/3/12.asp&NoWebContent=1

 

[DreXor]

is zone in that table? cause if it's not reserved, and it's throwing an error only on that condition, and when you change the field to something else it's happy, my assumption would be it's not in the table/crosstable you're pulling the RS from