Hi,
Can anyone please tell me how to get my DB table names into a recordset. I'm using the following code to create a recordset:

Dim rs As adodb.Recordset
Set rs = New adodb.Recordset
rs.Open SQL, conn, adOpenKeyset, adLockOptimistic

This works fine and I can get all the info that I need from the DB, but how do I get the relevant table names aswell??

Any suggestions or help would be greatly appreciated!
cheers,
shovels