|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 24th, 2010, 07:51 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
Make Query or Linked Table Read Only
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 
|
| Thread Tools | |
| Display Modes | |
|
|
Threaded Mode