jz1english
asked on
Need to Block Outside Users from Making Changes in Access DB
Hello,
I recently created a drop down menu that outside users can use to specify criteria they wish to view within the database I have created. Once they have specified criteria and run the filter command they are brought to a form which lists the records they searched for. What I need to do is block the users from making changes to the records presented in the form once they get into it. Mistakes will result in changes to the master table which the form is based on. I can't have that. Is their any way I can block them from making changes?
I recently created a drop down menu that outside users can use to specify criteria they wish to view within the database I have created. Once they have specified criteria and run the filter command they are brought to a form which lists the records they searched for. What I need to do is block the users from making changes to the records presented in the form once they get into it. Mistakes will result in changes to the master table which the form is based on. I can't have that. Is their any way I can block them from making changes?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks...
The query I set up gives two options: One commond gives the results in a form, the other in a Report. I needed to protect the report. Although, you have made me question weather I even need the form view as part of my query. Thanks...
The query I set up gives two options: One commond gives the results in a form, the other in a Report. I needed to protect the report. Although, you have made me question weather I even need the form view as part of my query. Thanks...
ASKER
In my comment above, I meant to say, "I needed to protect the form."
It seems like a REPORT is what you are trying to generate for your end users...