Hi Fabio

Sorry, I misunderstood your question. I have never used DBCs, and I probably never will. For my personal use I see only a few advantages, but many disadvantages. I tested it for a long period some years, but I only grew grey hair <bg>.

>Hi Tore,
>
>>What about AUSED()
>
>You suppose this:
>

> Database DBC1                      on file ....\DBC1.dbc
> DBC1.TableObject   tableName1      on file ....\...\fileTable1.dbf
>
>the table is open with:
>USE DBC1!tableName1 IN 0 ALIAS tableAlias1
>
>but i donnot known this ( otherwise the question is useless )
>
>Now:
>Simplified ipothesis: i known that tableName1 is a table.
>
>I search for DBC1!tableName1 is open.
>
>1. i must get DBC1!tableName1 DBF file
>for do this :
>DBGETPROP("tableName1", "table", "Path")
>convert it to absolute path
>
>now: AUSED(aTables) return list of Alias
>but i donnot known where is DBC1!tableName1.
>
>then:
>scanarray aTables
>  IF  DBF(aTable)matching with absolute path
>     * now i know that it is open
>  ENDIF
>endscanarray
>

>
>Another way ( fast if it is not open, very slow if it is open) is:
>

>TRY
>  USE DBC1!tableName1 IN 0 ALAIS .... without AGAIN
>CATCH
>  * test ERROR equal to Error 3
>ENDTRY
>

>
>A big job for a simple answer.
>
>Fabio