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"