Menu
Simba Technologies
Simba Technologies

Simba ODBC Drivers
Quick Start Guide for Windows

Simba > Drivers > ODBC Quick Start Guide > Troubleshooting > Known Issues When Using Microsoft Office

Known Issues When Using Microsoft Office

The following are known issues that you might encounter when using Microsoft Query or Microsoft Access to work with virtual tables.

Invalid Primary Keys

In Microsoft Access, if a table contains cells that show #Deleted as the value instead of the expected data value, then the table might be using an invalid primary key. To diagnose this issue, check the primary key values in the table and the data type of the primary key column, and verify if either of the following situations apply:

  • The primary key value is not unique. Access does not allow primary keys to be used by more than one row in the same table. Each primary key in a table must be unique.
  • To resolve this issue, make sure that the table does not contain any rows that share the same primary key value.

  • The primary key column is of an unsupported type. Access does not support the following data types for primary key columns:
    • SQL_BIGINT
    • SQL_WCHAR
    • SQL_WVARCHAR
    • SQL_WLONGVARCHAR

    To resolve this issue, convert the column to another data type, such as SQL_INTEGER or SQL_CHAR.

Invalid Column Names

In Microsoft Access, if you encounter an error message stating "[ColumnName] is not a valid name" (where [ColumnName] is the name of a column in your result set), then the column name contains special characters that are not supported by the application.

In Microsoft Query, this issue returns an error message stating "Qualified column could not be bound".

If you are working with a NoSQL database, then this issue might be caused by the separator characters that the driver uses when generating a schema definition. To resolve this issue, change the ODBC column name in the schema definition (the dsiiName or SQL Name) to a valid name, based on the following guidelines:

  • The column name starts with a letter of the alphabet or an underscore (_).
  • The column name only contains characters that are a letter of the alphabet, a number, or an underscore (_).

Simba ODBC drivers that support NoSQL databases include the Schema Editor application, which you can use to change the column names in the schema definition. For information about using the Schema Editor to rename columns in the schema definition, see the Schema Editor User Guide.