Jolene-

>[snip] tries to reuse this file, it will tell me that it is already open. Seems like if the files is open, the process returns an error stating that it isn't and if it isn't open it returns an error stating that it is already in use.

I suspect you either have the table still open implicitly as happens when you use a view or create cursor using SQL-Select, in which case, the AGAIN will do the trick.

Or, you could get the message if the table is used exclusively in a different (private) datasession. But that doesn't really sound like the behavior you see.

HTH