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?
