>I have an application that allows a user to view and approve records
>in dbf A . When he approves them they are transferred to data
>file B on a server by means of:
>
>use file b:
>append from file a:
>
>Periodically a user prints the transactions that accumulate in file
>B and clears it out, putting the records in an archive file C.
>
>use file b:
>do printing
>use file c:
>appe from file b:
>use file b:exclusive
>dele all
>pack
>use
>
>
>During the moments of printing the first user tried to append records
>to the print file (B) and got an error causing the exe to blow up.
>
>How do I control this situation? Can I tell B is in use and stop
>the first process until it is clear?
>
>Thx (A LOT) in ADV
>Chris
You do not need 50 different TABLES. Just use one TABLE and use a field as a flag to get the information you need.
Example.. approved = true or false