|Product:||DB Connectivity ODBC Products|
|Summary:||After linking the host table to the local database, ‘######’ values are received instead of valid data. Occasionally, the “Deleted’ or “Removed” message is displayed.|
After linking the host table to the local MS Access database, the linked table column names appear correct, but the field data is displayed as ‘Deleted’ or ‘#######’ or ‘Removed’. When selecting one cell, opening it, and sorting it in ascending/descending order – the correct value is displayed.
This kind of error usually appears when MS Access cannot find a UNIQUE index on the host database.
Things to check:
- When you linked the table, did MS Access ask you to define a set of fields that constitute a local unique index?
- Open the table in Design View. Do you have some fields defined as keys?
- Do you have unique indexes defined in your table on the host?
- Do you need to make updates to the host using linked tables?
A Possible Solution
It may help if, when linking a table through Access, you disable the checks on SQLStatistics and SQLSpecialColumns. This way, Access thinks that the table has no indexes and (although it becomes read-only) access is much quicker.