Security for SQL tables is controlled by the SQL server. When you link to
the tables, the best method is to use a userID and password that have read
only access. If you use an ID that has update access, there is no way to
prevent the user from accidentally updating data unless you lock down the
application and use only forms to view data. The form properties can be set
to disallow updates but the "no-update" logon is by far the better/safer
solution.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
