You'll have to try to USE the table and catch the error with ON ERROR if it can't be opened. The reason you can't use FOPEN is that on a busy system, it is possible for a second user to open the table between the FOPEN and the USE.
>How do you check to see if a file is open without attempting to open it first?
>
>I looked at FOPEN(cFileName, nAttribute) and wonder if this would do the job, or is there more to this? I have done this a long time ago, I think.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer