I've tried everything suggested, but nothing seems to be working. I think the problem is that the SELECT statements leave the table open, even though I issue a USE statement to close the tables after the final SELECT statement. How do I close the tables that the SELECT statment opened?

>Jeff, Check where you have put the Set Index statement, and be sure your syntax is correct for the type of index - for instance, if you have a CDX index, you'd use SET ORDER TAG xxx
>
>You can try moving the Set Index To xxxx up into the if clause, right after the USE pd_payments command.
>
>Barbara
>
>>I added the "SET INDEX" statement. It runs fine the first time. Now the second time through I'm getting the "File is in use error" again, this time it is occurring on the "SET INDEX" statement.
>>
>>>After your 'Use pd_payments' statement, be sure you add the index statements
>>>
>>>if !used('pd_payments')
>>> use pd_payments
>>>endif
>>>select pd_payments
>>>SET INDEX TO PD_PAYMENTS
>>>SET ORDER TO 1
>>>
>>>Of course, you'll change the name of the index to the correct one.
>>>HTH
>>>Barbara
>>>
>>>>Thanks for the reply! I replace my USE statement with the code you indicated, but now I'm getting another error: "Table has no index order set" when the SET ORDER TO 1 command is run.
>>>>
>>>>>your select statement is using that table again.
>>>>>try
>>>>>

>>>>>if !used('pd_payments')
>>>>>    use pd_payments
>>>>>endif
>>>>>select pd_payments
>>>>>...