Invalid SQL statement

[Mafat]

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!

[parksie]

What query are you using? I normally just use db.OpenRecordSet("SELECT * FROM table").