Share via

How to lock a table in Access so the data can not be manipulated?

Arianna D'Agostino 1 Reputation point
2021-01-04T16:11:00.517+00:00

Hello,

I have a table with many queries and
I don't want the data to be edited in the query and change in the table I would like that information to be locked so it cant be edited but I need the end of the table to be able to be edited but not the first couple of columns.

Is there ways to lock the tables or individual columns

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
4,006 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Daniel Pineault 441 Reputation points MVP
    2021-01-06T23:27:00.873+00:00

    No.

    Users should never be accessing tables and queries. Setup a form for this. You can have a continuous form as read-only displaying your data, and a separate form to allow data entry.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.