Richard,

There is a DBUSED() function. Should be helpful.

good luck,
Jim N

>You can open multiple databases at one time? i.e:
>OPEN DATBASE ONE
>OPEN DATBASE TWO
>OPEN DATBASE THREE
>and you can do:
>USE ONE!TABLE1 IN 0
>USE TWO!TABLE2 IN 0
>USE THREE!TABLE3 IN 0
>
>How can you tell that table1 is open in database ONE, and table2 is open in database TWO, etc.? The USED() function does not provide for specification of which database you are wanting to see if the table is opened in. i.e.:
>IF USED("TWO!TABLE2") does not work (returns a false every time).