Search results for query: *

Too fast!!!! I thought the record would disappear in the compact/repair. It didn't - but it became deletable!! Phew!!!!!

I appreciate the attention. Tried the repair/compact - I don't know why I didn't think of it myself. Anyway, unfortunately it didn't work. The link problem is huge - I really do not think there is any easyway to overcome that. What I may end up doing if I cannot do anything else is write...

Thanks Zameer However, the field in the set is autonumber and is the primary field used by almost everything else as a link. There are many deletions so I cannot copy the existing undeleted records to a new set without changing the index field values and hence losing the links to everything else

I have a record set in an Access 2002 database Suddenly a record has appeared with the value 1612544 in an autonumber index field - the maximum "real" value in it is 39703 When trying to delete the record I get an ISAM seek error 3709 - no matching values in the index. This data set represents...