Linking Tables from SQL to Access 2007

[desireemm]

I am thinkning about linking a sql table to access, but the sql permissions
dont apply when you link a table how do you fix that, or implement them for
the users?

 

[Arvin Meyer [MVP]]

I am thinkning about linking a sql table to access, but the sql permissions
dont apply when you link a table how do you fix that, or implement them
for
the users?

SQL permissions always apply in SQL-Server. If your users don't have
permissions, they won't be able to read/write data to SQL-Server.

 

[desireemm]

Ok cause I did a link server in Access and then tried linking tables and it
seems like the permissions dont apply

 

[Arvin Meyer [MVP]]

Either the permissions in the SQL-Server database are not correctly set up,
or you have not accessed the data using those user accounts. Both situations
are possible. If you used integrated security on the SQL-Server, you may
have not sufficiently granularized those permissions. If you think that your
setup is correct, I'd describe your setup in a SQL-Server newsgroup,
perhaps:

microsoft.public.sqlserver.security

and ask why your permissions don't seem to be holding.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Sylvain Lafontaine]

After a few readings, I'm still not understanding what you're trying to
explain in your posts. You should explain with details what you are doing
exactly and what are those permissions that you are talking about and what
you mean exactly with the words "they don't apply".

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)