Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Access table name with blank problem
Message
 
À
25/11/2000 16:46:14
Christian Cote
Les Logiciels Onoma Inc.
Longueuil, Québec, Canada
Information générale
Forum:
Visual Basic
Catégorie:
Bases de données DAO/RDO/ODBC/ADO
Divers
Thread ID:
00445401
Message ID:
00445404
Vues:
20
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform