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 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?