>Hello Cetin,
>
>Been having a problem with this form, it stopped working at a customer recently for no reason, it was crashing when the form tried to load the dataenviorment. Error in record 11, record not in index? Not sure what that means but after playing around I deleted all the tables from the forms dataenviromaent and re-added them back into data enviroment. This cured the error but now new records don't get added. After the the tableupdate the records pointer goes to eof?

Maybe the table itself is faulty. Dorin pointed out a good link. I observed the situation before w/o a transaction too.
I'd recreate the table with all of its indexes, data etc.
A simple way of doing that might be :
-Create a new empty DBC and its files in another folder (get programmatic version with gendbc and run generated prg in that folder)
-Use new table
-Append from old table
-Close all
-Copy over old table files with new one
Cetin