How to get a table name from a Recordset

[Pat]

Is there a way to get the table name that the Recordset is opened for?

Thanks
Pat

[Lanny]

Pat,

You might try parsing the SQL statement looking for the table name after
the FROM keyword, as in:

SELECT * FROM Products WHERE ProductID = 12

This could get tricky if the tablename contains spaces and it is surrounded
by quotation marks. The SQL statement that generated the recordset is found
in the Source property of the recordset object.

Lanny

"Pat" <pwang@uclink.berkeley.edu> wrote:
>
>Is there a way to get the table name that the Recordset is opened for?
>
>Thanks
>Pat