First you need to decide if the data entered after you start processing is going to be included, or if you need to have a cut-off point before your program starts. You may want to put all of the data entered during the day into temporary tables, then copy them and ZAP the originals before you start processing the copies. Any data entered after you start processing will then go into the ZAPped tables and be held for the next day's processing while you work with the copies.

Second, you'll need an error handler that does NOT require user intervention - you'll have to decide which problems can be handled automatically and which should shut down the program (and even notify you be email or pager)

HTH
Barbara


>I'm about finished with a program written in VFP 6.0.
>
>It's purpose is to run at night (scheduled by NT4.0), to process data entered during the day.
>
>BUT....
>
>This data is also accessible at night by web.... so data entry can occur then too (but not very often).
>
>What would be a good way of buffering, and/or using transactions.
>
>There will not be anyone there to make human judgements about which data to accept if there are conflicts.
>
>Thanks!
>
>Tommy