Make Query or Linked Table Read Only

[Larry]

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!!

 

[Daniel Pineault]

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]

Thanks Daniel

That should work fine.

I had searched for every variety read only, read-only and every other think
I could think of. Access help is only helpful if you know what you're looking
for.

 

[Armen Stein]

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.

This should work fine, but I thought I would mention another approach,
to use passthrough queries. They're inherently read-only, and they're
very fast because all the processing is done on the server. However,
they use the server's syntax (not Access syntax) and they can't use
any Access or VBA functions. And they don't work for Master/Child
relationships on subforms and subreports. But did I mention they are
fast?

Armen Stein
Microsoft Access MVP
www.JStreetTech.com