Access to SQL linked table from MSAccess only works for certain users

I have 2 users who are in the same domain security group.

An access 2007 is setup with linked to SQL express 2005 tables.

Problem I am seeing is although the group has SELECT permission on a particular table only one of them can open it in access.

Have to add that the person who can open table was the original user on the PC. Then a new user had an account created on the PC but they cant open the table now. If logon as the original it works.

Any ideas please?

Malcolm

• Do both users have their own copy of the Access front-end? You may wish to look at stackoverflow.com/questions/5001649/… - Fionnuala
• Is the second user logging onto the domain? - David-W-Fenton