>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
HI,
I am trying to use this string for a recordset.source in ADO :
SELECT * FROM MY TABLE".
When I issue : ors.open, VB tells me that my SQL statement in incomplete or that the table MY is not found in the database. The name of the table is "MY TABLE". How can I resolve this ??
Thank you for your help
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Surround it with square brackets -- [the expression].
The whole problem with the world is that fools and fanatics are always so certain of themselves, but wiser people so full of doubts. - Bertrand Russell