Weird data corruption

[Damob9K]

Hello,

I am working on some forms and using a few runSQL statements (I have another post about this) and am using test data in a table that I keep on deleting re adding and editing via the forms + SQL statements, but every now and again (has happened 3 or 4 times today) suddenly the data in the table corrupts and everything changes to what looks like Japanese writing.

Please see attached.

The only way to get rid of it is to close the DB, reopen, compress and compact, close again, then delete the record from the table.

Any logical explanation for this ? or has anyone seen this before ?

I'm in the UK so using en GB in office which is Office Pro 2010 x64

Any ideas ?
Cheers
Damob

 

[burrina]

My guess is that you have a record that is already open while being edited. You definitely have some sort of corruption. Hope you keep backups.

 

[Damob9K]

It's only test data, not a live database yet, Think i may have resolved it by sorting out the other issue with my SQL statements.

Thanks for you input .

Damob