>I have been trying to find a way of properly committing/protecting data to tables in the event of a power fail.

The trick I'm investigated lately is, given a table, would look like this:

lparam cAlias
cDbf=dbf(cAlias)
select 0
use (cDbf) alias __temp again
go recc()
cFld1=fields(1)
cVal1=value(cfld1)
blank field (cfld1)
replace (cFld1) with (cVal1)
use
return

I was doing some heavy thrashing in an app which was doing some very nasty things, and I expected regular crashes (though I didn't get as many as I expected). Using this technique, I always had the last records right, i.e. never lost whatever I had there at the moment I called this method. May be a little slow, but seems to work.