Kbase P62388: Table is seen as #del in Access
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/13/2004 |
|
Status: Unverified
SYMPTOM(s):
Table is seen as #del in Access
Table has an extra row with Crystal Reports.
The same table is not showing at all in Report Builder
Cannot see the record in MSQuery.
Changed the query to do a filter on fiscal year and company and saw the record in MSQuery.
Cannot specify the query that way in Access.
CAUSE:
Index corruption. Access and MSQuery are using different indexes to find the same record.
FIX:
Reindexed the database.