>Hi Jos,
>
>>The specific problem I wish to protect against is a crash of the update routine somewhere during the update process. What is the recommended solution using VFP9/SP1.
>
>I would make them transactable (MakeTransactable function) and then proceed like with database tables.
Christof, is it possible to wrap the entire procedure so that all tables currently open, or to be opened, are made transactable, then issue BEGIN TRANSACTION, then run the existing routine (which may open other files), then issue END TRANSACTION to commit all changes?
I also have exclusive access to all tables btw.
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.