HOW DO I MAKE THE RESULTS OF A QUERY READ-ONLY?

[pwel]

I have a simple query that looks up all the records in my db. The results are displayed in datasheet view, but the contents are editable.<br><br>How do I make the results of the query READ-ONLY?<br><br>Any help will be much appreciated.<br><br>Paul W.

 

[DougP]

Well if you create a Macro that opens the query you can specify that it open &quot;Read-Only&quot;<br><br>Are you concerned that your users are editing data?<br><br>Then you need to make Macros and Custom Menu buttons and instruct your users to use them instead. <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[pwel]

Thanks very much Doug.

 

[elizabeth]

A little simpler, you can open the query's property sheet adn set the Recordset Type property to Snapshot. This is good if they are happy to cooperate.<br><br>A little more complicated, you can set up Access Security and remove the Insert, Update, and Delete permissions on that query. This is good if you suspect soemone of intentionally making changes they should not.