I have a VB6 program which connects to an Access database using ADO.

Sometimes when I try to open a Recordset object with one of the tables / queries in the database as a source, I receive the message: "Invalid SQL statement", although the table / query is in the database! When I then terminate the program and execute it again, I receive no errors!

What can the reason for that be?

Thanks!