get table name

Hi,
how can i retreive a tble name from adodb.recordset object?I don't understand what you want... do you mean how to get all the table names from a database, or how to get the table name from an already opened recordset?
If your question is the second, i dont think it is possible, remember that a recordset can have records from more than one table.