I have a front end database that I want to restrict user access to only enter data into a form. I do not want them to be able to scroll through other entries via the form. How can I restrict this in Access 2007-2010?
3 Answers
There's a property on the form called DataEntry DataEntry property documentation
If you set it to True, it will only allow new additions, it will not show you other records.
Create a form based on that table, and only include the fields you want them to be able to edit. Alternatively, you can add all the fields (for visibility) and disable (in the field Properties) the ones you want to be excluded from edits. They will still be visible on the form, but the data they display cannot be edited.
You can passacFormAdd
as anDataMode
argument on DoCmd.OpenForm to allow only adding records.
Second option: have a Where-Condtion in Recordsource that doesn't fetch data likeWhere 0 = 1
. That will leave form empty as condition is never met.