Thanks for the answers Trey.

>Either it got used as a table
>or is open in another data session
>or it's being used by someone else on the network
>or a com server has it open, in which case you won't be able to see it open.
Yes, the DBC was open as a file in datasession 1. I consulted it and forgot to close it. oops!


>Just USED("PL") - you're only checking an alias name
>I would use:
>If Used("pl") And JustFName(DBF("pl"))="PL.DBC"
>JustFName being in FoxTools < VFP6
>Since it's checking an alias, USED() only works in the current data session.
I didn't know that USED only works in current data session, because it uses alias. I am not sure I understand your suggestion. How does one find out if a file "xx.yy" is being used in another data session? I guess normally it doesn't matter, but in this case it does.


>Can you not manually pick it from the viewer? I wasn't sure if you were only doing this is code.
>You could suspend and ACTIVATE WINDOW standard to pull up the standard toolbar and check the databases in use from the database combo.
I tried picking it from the viewer but it refuses to change to datasession 1.

Thanks a lot.

Alex