Corruption - relationship & primary key disappearing?!?

[CRS]

Hi, I've searched through the archives and cant seem to find an answer to my problem - hopefully someone may be able to shed some light on this for me as it is driving me mad!

One table in my database keeps getting corrupt records; I get various error messages when navigating a particular form - including 'Record is deleted' (when it hasnt been), 'The search key was not found in any record, 'Object invalid and no longer set' etc. After receiving one of these messages one or more records in my table corrupts (strange symbols and #Error# appears in the fields) - I have to compact and repair and delete the record.

I have imported everything into a new clean database several times but the same thing keeps happening.

Additionally the table that keeps corrupting is randomly 'losing' its primary key and relationships - they just simply dont exist anymore. I understand that importing into a new database could cause this - but they arent disappearing after I have imported; the database can be running fine and then after a few days I check the table again and the primary key is no longer set and the relationships to other tables have disappeared.

I am compacting and repairing every day and having to recreate a new clean database about once a week - and keep getting the same problems with the same table!!!

Has anyone seen this happen before and could anyone suggest where I would begin trying to resolve this. Any advice would be REALLY appreciated.

Many Thanks in advance

 

[Pat Hartman]

I had a similar corruption problem which turned out to be caused by a corrupted form. To correct the problem I had to do several things:

1. Create a new empty db and import everything except the table and form.
2. Export the table to a .csv file
3. Import the .csv file into the new db.
4. Recreate the corrupt form in the new db. Hopefully it is not a large or complicated form. You should be able to copy and pase any code but I would recreate all objects rather than copying them.

 

[CRS]

Hi Pat,
Thanks for your reply - I'm going to give try it today so I'll let you know how I get on.
I've never had to posted anything before as I've always found the answer I needed in the archives - and I have to say some of your advice to others has also been really helpful to me. Keep up the great work!
Cheers again