Access Security Issue

[ddtpmyra]

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?

[Stewart Ross]

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