Search results for query: *

The answer for the field level security can be found at:<br> <br> <A HREF="http://support.microsoft.com/support/Access/Content/SECFAQ.asp#Item25" TARGET="_new">http://support.microsoft.com/support/Access/Content/SECFAQ.asp#Item25</A><br> <br> What you do is change the permissions for the record...

Still having trouble but getting closer.<br> <br> I created a query in design view and put that query name as the record source in my form. Everything worked as long as the user had permission to read update and insert data in the query. If I took these permissions away the user could not add or...

I want to secure the database as mentioned in your second posting on 2/17/2000 -- Use Access security to make the table inaccessable to all groups, and put code behind the form to open the table &quot;with owner's permissions&quot;.<br> <br> I can do the first part (use Access security to make...

I have the form set up with fields locked that already contain data. I also have several filters on the form to help users find the records they need. Everything is looking good and I am securing the database.<br> <br> How do I set up the form to open the table &quot; with owners...

I have Elizabeth's way working in a test case. With some clean up I can make it work. <br> If I used Bill's suggestion, Is there a way to prevent users from accessing anything that can change the table except by using the form that has the records locked? <br> <br> Thanks to both of you for the...

I am new to creating anything complicated in Access. I need to create a database of drawing numbers. The database will have fields for approvals by several different groups. Only members of the group should be able to write to that group's approval field.<br> <br> I found a thread (Jan 4, 2000 -...