BLOB has been modified!

[EricDraven]

Help!

I have just one user who keeps on getting this message when trying to access a table (paradox). I have read quite a bit about this error and understand it to be something about the BDE and not a programatical error as I first thought. What I need is the help of someone who has come across this error and successfully eliminated it. I know that I can repair the table by deleting the offending records, but I want to stop the error from occuring in the first place.

I can safely say it has been the cause of many a stressful moment for me this week!


When your feeling down and your resistance is low, light another cigarette and let yourself go

 

[Svanhooft]

hi,

The error can be removed with the dtutil32 program.

Steph [Bigglasses]

 

[EricDraven]

Yes but does this just remove the error once it has occured? I want to know what the root cause of this error is as it is driving me crazy!

Could you offer any more information on this dtutil32 program please?


When your feeling down and your resistance is low, light another cigarette and let yourself go

 

[Svanhooft]

hi,

dutil32 is a program made by borland along time ago and never been updated. Running this program rebuilds the database and in 99% of the cases the error is gone.

The blob error occurs when there are problems with updating a table. In a network you get this error when you donn't force the bde too write to the database. The BDE is buffering information. When the computer crashes or a user edits a record and doesn't confirm the update. You get troubles in the database. Mostly the records aren't updated or in case of a blob it generates an error.

hope this helpes.

Steph [Bigglasses]

 

[DeerBear]

Hi EricDraven,

I would say you should lock the table and
refresh data after each change. Locking the
table will stop others from accessing a record
while it's being modified, so that it should put the
word "end" to the error.

Cheers,

Andrew