A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Make Query or Linked Table Read Only



 
 
Thread Tools Display Modes
  #1  
Old February 24th, 2010, 08:51 PM posted to microsoft.public.access.tablesdbdesign
Larry
external usenet poster
 
Posts: 464
Default 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
  #2  
Old February 24th, 2010, 10:14 PM posted to microsoft.public.access.tablesdbdesign
Daniel Pineault
external usenet poster
 
Posts: 658
Default Make Query or Linked Table Read Only

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

  #3  
Old February 24th, 2010, 11:17 PM posted to microsoft.public.access.tablesdbdesign
Larry
external usenet poster
 
Posts: 464
Default Make Query or Linked Table Read Only

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.
--
Regards
Larry


"Daniel Pineault" wrote:

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

  #4  
Old February 28th, 2010, 07:22 AM posted to microsoft.public.access.tablesdbdesign
Armen Stein[_2_]
external usenet poster
 
Posts: 157
Default Make Query or Linked Table Read Only

On Wed, 24 Feb 2010 13:14:01 -0800, Daniel Pineault
wrote:

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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:41 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.