>>>
>>>I would prefer not to break the batch up into smaller groups of records because I really want a single Journal Entry for each invoicing process.
>>>
>>>Thanks,
>>>
>>>Ken
>>
>>Ken, you network may only allow so many "locks" - I'm not sure if this is important in TRANSACTION / COMMIT because I don't know how it's implemented - but might be worth a quick look esp. if you are running Novell, which is limited to about 2000
>>Regards
>
>Hi Dave :),
>
>From what I understood, transaction management in VFP does locking at the table level. I would expect that this limits the burden on the Network OS.
>
>Marc

Hiya Marc :-))
Hmmmmm.... I wonder what happens in an heavy user environment when someone always has a record lock somewhere?? May it tries a table lock, then reverts to multilock on failure????