Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 297
  • Last Modified:

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?
0
jz1english
Asked:
jz1english
  • 2
1 Solution
 
SjoerdVerweijCommented:
- Open the form in design view
- Open Properties
- Set Allow Edits, Allow Deletions and Allow Additions to False
0
 
MedflyCommented:
It there a specific reason you have the results of the query dump to a FORM instead of a REPORT?
It seems like a REPORT is what you are trying to generate for your end users...
0
 
jz1englishAuthor Commented:
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...
0
 
jz1englishAuthor Commented:
In my comment above, I meant to say, "I needed to protect the form."
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now