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...
What schema are the tables in. It seems to me that I recall a problem displaying tables that aren't in the default dbo schema, but I may be conflating issues. Please verify whether this is a factor here or not. Thanks.
Yes, all of our tables are outside the default schema.
- I think Colin's suggestion should work here.