Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Access table name with blank problem
Message
 
To
25/11/2000 16:46:14
Christian Cote
Les Logiciels Onoma Inc.
Longueuil, Quebec, Canada
General information
Forum:
Visual Basic
Category:
Database DAO/RDO/ODBC/ADO
Miscellaneous
Thread ID:
00445401
Message ID:
00445404
Views:
18
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform