Locking down a table

[clcole]

I'm trying to see if there's any possible way I can lock down and password protect a single table in a project?

The overall issue is that I need to display a table that will display
ID, Name, Address, Status and require a password to update anything except the Status.

Currently I have a table that lists
Table1: ID, Name, Address
as well as a table with the members
Table2: ID, Status

With ID linking the two. Is there a way I can run a simple query to show all of the data but only allow the data from table 1 to be edited? It seems there should be an easy way to do this but I can't really find anything short of having to create a form and code it myself.

[ADezii]

I'm trying to see if there's any possible way I can lock down and password protect a single table in a project?

The overall issue is that I need to display a table that will display
ID, Name, Address, Status and require a password to update anything except the Status.

Currently I have a table that lists
Table1: ID, Name, Address
as well as a table with the members
Table2: ID, Status

With ID linking the two. Is there a way I can run a simple query to show all of the data but only allow the data from table 1 to be edited? It seems there should be an easy way to do this but I can't really find anything short of having to create a form and code it myself.

Create a Form whose Record Source would be a Query consisting of both Tables. Set the Locked Property of the Fields on the Form to Yes if you do not wish them to be edited.

[Proaccesspro]

Create a Form whose Record Source would be a Query consisting of both Tables. Set the Locked Property of the Fields on the Form to Yes if you do not wish them to be edited.

Is there a way to password protect a table?

[ADezii]

Is there a way to password protect a table?

You can Hide a Table but to the best of knowledge, you cannot Password Protect it directly. If this is of great concern to you, set up a Security System where you assign specific Permissions to this Table via established Groups.