ODBC won"t show new tables

turkee

Registered User.
Local time
Today, 10:37
Joined
Feb 20, 2011
Messages
13
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?
 
Problem solved, although I don't know how. It was not Access or SQL, but apparently had someyhing to do with the permissions on the Windows server side.
 

Users who are viewing this thread

Back
Top Bottom