Hi,
Try USE Employee AGAIN

>Hi,
> I am facing below problem in Visual Foxpro. Here is the problem & little code.
>
> SELECT 0
> USE Employee ALIAS Empl && ( This file is opened in someother Function)
> * When control comes back, I am trying to open once again.
> SELECT 0
> USE Employee
>
> IT SAYS 'FILE IS IN USE'. So now how do I know that file is already opened. Now suppose I will make use of USED() function.
>
> IF USED('EMPLOYEE') - IT SAYS NO. Because it checks with ALIAS not table name.
>
> Ofcourse I have solution for this using AUSED() function. Get an array and find out each Alias's table name using DBF().
>
>BUT MY QUESTION IS, IS THERE ANY FUNCTION WHICH CHECKS WITH TABLE NAME INSTEAD OF ALIAS ?