Cannot link SQL Server 2008 Table to Access 2007

[samdman]

I created lookup table with primary key in SQL Server 2008. I assigned correct permission to that table. But it won't link to Access 2007 when I use 'Linked Table Manager'. I can see other tables in SQL Server through Access 2007.


Anyone know of a way to get this done?

 

[Galaxiom]

Are the tables that don't appear in the same database and using the same DSN?

I experienced this problem once with only some tables appearing after some changes were made to the database on the server though I think that was a coincidence.

I ended up recreating the DSN and that fixed it.

 

[samdman]

I can see other tables in the same Database. But newly created table cannot see there.