I have a db in MS Access that I am having problems linking tables too. I can get all other users except this one. When I try to link to the sql server tables, I can't see them (logged on as her). Of course, if Im logged on as me, I can see them. And if I link the tables under my login, when she tries to run the database, I get an error message "The SELECT permission was denied on the object...."
How do I change permissions? I have tried multiple things with no luck. I am a newbie with SQL Server.