I would like to be able to provide users a list of available tables (table names) when they connect to a new database (Access 2003). The tables will have have been made externally by the user and they point to the name of the file (e.g. MyAccess.mdb) to access the data.
Does anyone know how to access this information? I found articles on "TableDirect" but have not been able to see examples of implementation and the help files seem to indicate this is used for reading from the tables.
Much appreciate any help