Query Field Security

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bymarce - 09 Nov 2007 19:58 GMT

I am building a database for scientific data. All samples that we test have
a catalog number. How can I prevent my users from editing this number or
warn them that they have when they are looking at data from a query? I have
already set up user level secruty so that only full data users can edit the
table in which these numbers are stored. I also have my forms set up to warn
users (through a message box) if they edit the catalog number through a form.

Reply to this Message

Jerry Whittle - 09 Nov 2007 21:40 GMT

Build the query to get the data returned properly.
Next while in design mode to up to View on the menu and select Totals.
That will make the query unupdateable. Records or field in records can not
be added, deleted, or edited in such a query.

You could also open the query in SQL View and after word SELECT put DISITNCT
as in SELECT DISTINCT .

Signature

Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> I am building a database for scientific data. All samples that we test have
> a catalog number. How can I prevent my users from editing this number or
> warn them that they have when they are looking at data from a query? I have
> already set up user level secruty so that only full data users can edit the
> table in which these numbers are stored. I also have my forms set up to warn
> users (through a message box) if they edit the catalog number through a form.

Reply to this Message