Kbase P5263: Unique identifier column as primary key gives wrong output with access 2000
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1C
ODBC SQL 92 Merant driver
MS ACCESS 2000
Windows NT 4.0
SYMPTOM(s):
When you use Access 2000 to link a SQL Server 7.0 table that contains a Unique Identifier column as the primary key, #DELETED is displayed for all records in the result set.
CAUSE:
Microsoft issue
FIX:
To resolve this problem, install Jet 4.0 SP4.