I am doing a relatively simple SELECT query on an Access table to retrieve some data. VERY BASIC STUFF!

During the procedure, I use a recordset object with the same name multiple times for mutlipe different queries - I just close then re-open recordset each time I want to use a different SQL string. OK?!

This works fine for two queries, but the third (identical style) falls over at the "<Recordset>.Open <SQL SELECT statement>, Connection String>, adCursorForwardOnly" line with the error message "Automation Error (next line) Unknown Error."

I am using ADO 2.0 and Jet 4.0, and have checked and double checked the spelling of all my objects.

What could be the problem?

Regards.