Forum Discussion
Blank table names when trying to link ODBC tables in Microsoft Access
I am trying to create a linked table via External Data -> New Data Source -> From Other Sources -> ODBC Database in Microsoft Access. I am able to successfully connect, but when the Link Table window...
I've also had problems linking to tables that aren't in the default schema.
However, one other thought. In the Navigation options in Access, try ticking Hidden Objects and System Objects. Do the linked table names appear now?
- I tried ticking "Hidden Objects and System Objects" and the tables still not show.
- What is the data source again?
- The data source/driver is the driver from Syware https://www.syware.com/products/odbc_driver_kit.php . We build the driver ourselves though and are able to make code changes as needed.
