Known Issues with the Single-Tier "Lite" Edition OLE DB Provider for ODBC Data Sources -- Visual Basic 6 and ADO
- When specifying the SQL for the Recordsource property in an ADO Data Control (ADO DC), you must quote the table name.
- If you do not quote the tablename, VB will convert your SQL to lowercase and then quote the table name when attempting an update; e.g., if you enter
SELECT * FROM EMP
when attempting an update, this will become
update "emp"
when VB submits the query to the DBMS.
Databases which support case-sensitive schema object names (which include most modern DBMS) will then either reject VB's query, complaining that the table doesn't exist, or deliver results based on the wrong table.
- To avoid this problem, enter the query as, e.g.,
SELECT * FROM "EMP"