Prev: Church Database
Next: Church Database - stevie pimps agan
From: Larry on 24 Feb 2010 14:51
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
From: Daniel Pineault on 24 Feb 2010 16:14
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
From: Larry on 24 Feb 2010 17:17
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
From: Armen Stein on 28 Feb 2010 01:22
On Wed, 24 Feb 2010 13:14:01 -0800, Daniel Pineault
<DanielPineault(a)discussions.microsoft.com> 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

 | 
Pages: 1
Prev: Church Database
Next: Church Database - stevie pimps agan