Share via

Microsoft Access: allow adding new data, but not changing existing data

Anonymous
2019-07-31T13:21:52+00:00

Can one allow a user to add new data in a form/table but not change data that is already in the form/table

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Duane Hookom 26,825 Reputation points Volunteer Moderator
    2019-07-31T13:33:02+00:00

    Hi Marcell,

    You can set a form's properties to not Allow Edits but Allow Additions. This is not the case with tables but users should not be allowed to enter into tables.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2019-07-31T17:40:28+00:00

    OR...

    Lock the Form and create a pop-up for adding new.

    Was this answer helpful?

    0 comments