Query Field Security

B

bymarce

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.
 
J

Jerry Whittle

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 .
 
Top