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.
"We build the driver ourselves ....."
That might explain it, I guess. We were assuming you used one of the standard MS drivers, like this one for SQL Server. All bets are off, I think, under those circumstances. It also begs another question. Where is the data? I had also assumed it was in a SQL Server database, but is that the case?
