I doubt there is a resolution for this, but if anyone knows the cause, it would be a star
Have a large (near 1GB) database which stores resumes in a blob field.
Several days ago I noticed that a resume was missing - this happened a few times recently, but was not a great problem. I tried to open it and received a message, "blob has been modified." The Database froze and needed to be shut down forcibly. (I know, it's not good). Revisiting the record produced the same result, but it was possible to navigate away from the record to others. Trying to access the blob field in others produced a lock, although neither W7 search nor other aps were able to find pdoxusrs.lck and I could not find the .net file where it should be.
I reinstalled what appeared to be a broken BDE engine, relocated net share, repaired the table, deleted and reentered the record and had one problem -free run before the same issue appeared with another record.
Running through the table, I find that recent records - as far back as two years - are missing blob field entries - that covers about 500 records. Recreating another record, closing then reopening PDox caused the document to disappear.
A recent backup exists, but importing the Blobs will be of little use, if this behavior is to repeat itself. My suspicion is that it will (as the originally repaired table needed to be repaired again.)
Let me add that repair review indicated that the filed pointed to a memo field, but no more.
CAn anyone give me an idea of what might be stripping the documents from the Blob containers?
A note: These were entered, as all have been entered for the life of the database, by using a clipboard program. The records were exited and reopened each time to confirm successful record completion.
Thank you.