Using Access forms to update access database

Question

Hello,

I am a novice at using Microsoft Access.  I need to figure out how to do the following: multiple end-users can fill out a form, which then updates a database.  I want the user to not be able to edit the database; only update it with the particular entry.

I figured out how to split the access database into a back-end database and a front-end form.  However, on the front-end form the user can still edit previous records.  They can do this by the navigation pane (that enables them to double-click the 'table' and change entries) and also on the bottom pane (which enables them to click on the 'back' and 'forward' arrows, navigate through the records, and change them).

How do I restrict access to the end-user so that they can only fill in the current form?

Thanks!

Answer 1

Yes, In the Options disable the Nav Pane so they don't see it at all. You can also disable the ribbon and make your form the default form so that's all they see. 

There are a number of other things that can be done to limit the access a user has. You might find my blog on Login Security with VBA helpful. A search on securing Access apps will get other tools.

Answer 2

Hello there

I have a question

I am building a  data base with access

I don't want the user to have access to the table

i just want the user to see the forms and be able to add data and view data

any way i can accomplish this?

thank you

Answer 3

I will check out your suggestions.  For now, just disabling the ribbon and Nav pane works fine for what I need.

Thanks

Answer 4

Thanks for the help, Scottgem.  This helps me prevent the user from editing/deleting existing records via the form.

The user can still edit existing data by clicking on the table, however.  Other than setting the table to "hidden" is there a more secure way of preventing this?

Answer 5

You weren't exactly clear, but I think you are saying you want users to only add new records and not edit existing records. If so, the easiest thing to do is set the Data Entry property to Yes for the form. This will restrict the form to only entering new records.

If you need to be able to allow users to see existing records but not change them, you can set the AllowEdits property to No and prevent editing.