Preventing changes to source data

[TDC21]

I have been working on a search form that is starting to take shape, the goal will be to allow people in production to quickly search inventory from partial matches to identification tags. I would like them to be able to search a live connection but I dont want them to be able to make any changes to the source data itself.

I would think there would be a way to establish view only settings but I have not come across that option. Currently I am thinking about creating SQL table views from the actual source data and establishing the ODBC connection to those, that way if any changes are made it wont affect the "Live" database. Seems like there would be a simpler option that I am probably just missing.

As always any suggestions are appreciated

 

[ranman256]

set the query RECORDSET TYPE = SNAPSHOT, and they cant change data.

if you display the query in a form, set the form :
ALLOW EDITS = FALSE
ALLOW DELETIONS = FALSE
ALLOW ADDITIONS = FALSE

 

[xenou]

You should test it out - as far I as I know if you create a view (select query) from sql server as your source then you can't update the data. If you are just connecting straight to tables then maybe it's different - but why would you do that?!