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

Please don't piggyback your question on another thread. Please use the Participate link near the top of the page to start a new question and we will be happy to help.

There are many other threads that discuss this issue that you might want to check out before starting your own thread.