Open your query in design view
View - Properties
Click once is the grey area where the tables are shown, the properties
dialog should be entitled 'Query Properties'
Set the Record Type to Snapshot and the Record Lock to No Locks
Close and save your changes.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.



"Larry" wrote:

In Access 03 & 07 I have tables linked via ODBC to a MySQL database. Due to
many security, DB, and vendor issues, I do not have an option to change the
MySQL permissions or change the ODBC driver.

I need to find a way to make the linked tables read-only (preferred) or at
least make queries to those tables read-only. Simply locking the form's
controls is not sufficient. I had users accidentally delete data in the
MySQL anyway.

Any suggestions would be greatly appreciated. I'm bordering on having to
scrap a 3 month project if I can't secure the data.

Thanks!!
--
Regards
Larry