ISAM (MS Access) Visible record which does not exist!

[shellsman]

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 10 or more years hard labour so is rather dear to me. See http:\\

http://www.gastropods.com

for why!

Can anyone help?

 

[ZmrAbdulla]

Create a(or two) backup copy before you do anything more.
see this at google group

________________________________________________________________________
Zameer Abdulla
Visit Me
No two children are alike - particularly if one is yours and the other isn't.

 

[shellsman]

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

 

[ZmrAbdulla]

I never came into this situation.. From most of the posts that related to this is linking to db corruption. Repair/Compact may help you. There is a utility(Jet Compact) from MS.

http://support.microsoft.com/kb/295334

You can create a shell db and import the structure /and data to it. But not sure how to keep the autonumber intact if you copy & paste the records.

________________________________________________________________________
Zameer Abdulla
Visit Me
No two children are alike - particularly if one is yours and the other isn't.

 

[shellsman]

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 some stuff to read everything from this set and everything associated with it, then write it to new sets generating new link numbers wherever they are needed. Then I guess I will have to add the index numbers for new records by hand.

Painful!!!!!!

 

[shellsman]

Too fast!!!!

I thought the record would disappear in the compact/repair.

It didn't - but it became deletable!!

Phew!!!!!

 

[ZmrAbdulla]

Done!!

Being a Non-IT man, MS Access is my favourite software. Only part I don't like is its tendency of corruption!!

Backup > Do data entry > backup > do work >backup..

________________________________________________________________________
Zameer Abdulla
Visit Me
No two children are alike - particularly if one is yours and the other isn't.