Via visual basic code, I need to be able the dynamicly get the names of the tables in a database.
I was able to get the field names of a recordset easy enough, but I want table names within a connection.
ie. Order_Header_CN.Open "Provider=Microsoft.Jet.OLEDB.3.51;Data Source=" & strPath & "Order_Header.mdb", there are three tables within this database, how can list them out, via VB code??