Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 316
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

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