Kbase P129772: SQL: Fields are displayed as "#DELETED" with Microsoft Access
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
20/03/2008 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.1B
Windows
SYMPTOM(s):
SQL: Fields are displayed as "#DELETED" with Microsoft Access
All columns in the result set are displayed as "#DELETED" instead of their actual values.
Updating data using an MS Access 2003 ODBC Client
CAUSE:
The Default Isolation Level of the Data Source Name ( DSN ) is set to SERIALIZABLE.
FIX:
For read only data activities, set the Default Isolation Level of the Data Source Name ( DSN ) to READ UNCOMMITTED . For for UPDATE, INSERT or DELETE data activities, set the Default Isolation Level of the Data Source Name ( DSN ) to READ COMMITTED.