By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,640 Members | 2,110 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,640 IT Pros & Developers. It's quick & easy.

Access Security Issue

ddtpmyra
100+
P: 333
Just a general question on the the security issue on Queries riding on Access Dbase that has a link only connection on SQL server.

Are there high risk security involved?
Sep 19 '08 #1
Share this Question
Share on Google+
1 Reply


Expert Mod 2.5K+
P: 2,545
Hi. I'm not sure what you mean when you talk about 'security issues'. If Access is linked via ODBC to tables in a SQL Server database, and the user concerned has full rights to those tables, that user will be able to alter, delete, or add records at will in the same way as with native Access tables. He or she may also be able to change table structures to some extent (though not through the use of queries), again depending on the specific access rights granted. Such low-level access poses a potential risk (in the same way as it would for native Access tables) as users with unconstrained low-level access could potentially compromise or destroy the database if they so wished. Read-only access is of course safer, but this would preclude performing updates via Access queries.

It is hard to give a comprehensive answer to your question when it is expressed so vaguely, however.

-Stewart
Sep 19 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.