How to lock Microsoft Access table

Asked By malakasilon 0 points N/A Posted on - 08/19/2011

I am using Microsoft Access 2000. I have a database. Some tables are secret, but they have an internal relation. I want to lock some tables from there. Is it possible to lock some specific tables?

If possible, how I do this work. Please describe to me step by step.

• Status: Open
• Question Views: 2674
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Access

Best Answer by Shelby joy

Go To Solution

Answered By Am.Wright 0 points N/A #116154

How to lock Microsoft Access table

Definitely, yes! If your MS Access is a multiple-user database, it is undeniably essential to be distributed into configuration for a front-end and back-end. By the table at the back-end and at the whole thing is in the front-end. The two parties must have a copy of their own. front-end will be to the users and for the server is the hard drive with the back-end.

For one user, hiding is undoubtedly enough for tables. That's it. 🙂

About Am.Wright

Questions
0

Answers
12

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 08/19/2011
• Question Category: MS Access

Best Answer

Best Answer

Answered By Shelby joy 0 points N/A #116155

How to lock Microsoft Access table

Malakalison, yes, indeed it is possible to lock your tables in the database. This is the steps you need to follow:

1. Open Ms Access by going to Start->All Programs->Microsoft Office->Ms Access and open the program.
2. Create a form based on the table and show all the fields you want your users to update.
3. You can show fields in ReadOnly mode in the form.

The end user should not have direct access to the table.

• Tables will be used for data storage
• Forms are used for adding/updating or deleting data
• Queries will be used for extracting and manipulating data
• Reports are used for presenting data

The users will be blocked from editing anything in the table and will only read the data

This information should be helpful. Thanks

About Shelby joy

Questions
0

Answers
10

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 08/19/2011
• Question Category: MS Access