I have a barcode data collection system written in foxpro. I am feeding data to a canned business system. The business system has a posting program that posts data from my table into it's own tables. The problem is; the posting program requires exclusive use to purge out the records. Unless the program can get exclusive use of the table, nothing gets posted.

So, in my collection system I open the table like:

use 'bcexclusive' in 0 shared
*then I add to the table using the insert function
Insert into 'bcexclusive'..... etc
use in 'bcexlusive'

The employee may make 1 entry or 10 entries and each time the table is opened and closed. That table gets opened and closed over 1000 times a day.

Is there a better way?
I seem to have a bottle neck somewhere slowing things down, I think this it.
agree? disagree?

I considered leaving it open and periodically closing the table, say every 2 hours, but all the workstations would have to be synchronized. Seems to be a complicated solution. Perhaps there is a better way.