• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1256
  • Last Modified:

Make an ODBC connection to SQL read only on the Acces side- possible?

Using ODBC, I am connecting to a SQL server table in our main business system.  Is there any way that I can make this connection read only?  I noticed that it is possible to make changes directly in the table.  Users don't work in tables, but it still makes me leery and I would like to lock it down some how.
1 Solution
Patrick MatthewsCommented:
I would set up a user profile in SQL Server that has read-only rights, and then use that
user profile to establish the connection.
So there's no changing anything, not even via forms?
snyperjAuthor Commented:
right- is all lookup- comparing estimates to what was actually billed, if you will....
Well then I think Patrick nailed it.
you could use pass thru queries as the data source for your forms. pass-thru queries are read only.

Create a new query in design view. From the Query menu, select SQL specific, Pass-Thru query. Go to query-Properties and change the connection string (if you need help with this, let us know) Then write your query in sql view. save your query and use it as the data source for your form and the users will be unable to update the data.


Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Tackle projects and never again get stuck behind a technical roadblock.
Join Now