How to make query non-updatable

R

rduke15

Hi,

I would like to prevent users from updating data in query results
windows. Is this possible?

The point is to let users define custom queries, but prevent
accidental changes to the data itself. Changes must be done through
forms, which show appropriate warnings when needed.

I have looked at the query properties. All I found was the choice for
Recordset (Snapshot or Dynaset), but that didn't prevent me from
updating the underlying data.

Is this possible?

Thanks,

RD
 
M

MGFoster

rduke15 said:
Hi,

I would like to prevent users from updating data in query results
windows. Is this possible?

The point is to let users define custom queries, but prevent
accidental changes to the data itself. Changes must be done through
forms, which show appropriate warnings when needed.

I have looked at the query properties. All I found was the choice for
Recordset (Snapshot or Dynaset), but that didn't prevent me from
updating the underlying data.

Is this possible?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Create user-level security for 2 different sign-ons per user. One for
updating, but they can't create queries; the other for creating read
only queries. Create 2 groups: one for read-only and the other for
updating. The groups' permissions would only apply to the queries. The
tables would be off limits to all users. See the following articles in
the Microsoft Knowledge Base for more info:

148555 ACC95: Microsoft Access 95 Security White Paper Available in
Download Center

207793 ACC2000: Microsoft Access Security FAQ Available in Download
Center

254372 ACC2000: Overview of How to Help Protect a Microsoft Access
Database
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBSaQsKoechKqOuFEgEQLE5ACgqi6yGbv/7N+4sfwBt1iK0WZFFWYAoJ4y
59o0XSke9MjL7/E2wisNhi8r
=FFeL
-----END PGP SIGNATURE-----
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top