This is nuts. I have a SQL Server 2005 back end and a Access2010 front end. I linked all the tables I needed with an ODBC connection a couple of weeks ago and it worked fine. Now I made 2 more tables on the backend that I need to link in Access, but they won't show. I made a new connection, refreshed everything. The tables are the same owner and in the same database as all the other linked tables. I have admin priveleges. I can query the tables in SQL.
But I can't see them in ODBC.
Any ideas?
But I can't see them in ODBC.
Any ideas?