Hello there,
Are there any methods to determine the tables available in Access 2003?
Thank You
Astro
Printable View
Hello there,
Are there any methods to determine the tables available in Access 2003?
Thank You
Astro
You can use the tables collection using ADO or use the .OpenSchema method or an ADO connection object. Perhaps the TableDefs collection too.
Astro:
It sounds like you haven't connected to the database yet. Is your application running in Access and you want to look at the tables in the "current database", or is something else running and you want to peek into an external Access database?
Hello guys,
I'm trying to determine the number of tables avail and add them in the listbox. the list automatically adds up each time a new table is created.
Apologise for being too brief.
Astro