Protecting certain columns in a table

[Carly]

Is there any way in which I can protect certain columns in a table?

I am opening a table and I want the end user to amend the last column but I don't want them to amend any of the other columns. (They need to see these columns for reference).

Regards
Carly

 

[Ally]

Users shouldn't really enter details directly into a table. The way over this would be to design a form, disabling and locking the fields that you don't want them to touch, but enabling them to enter data into the fields you wish.

 

[Carly]

I knew that was going to be the answer I would get.

But even though I know that I shouldn't do it, is there no way that it can be done?

 

[Ally]

Not that I know of I'm afraid!

 

[AncientOne]

you can create a form that looks exactly like a table (Datasheet view), so it's difficult to understand your reluctance to use one. To ensure that your tables can't be edited by anyone you can hide them (won't defeat your average geek) or apply workgroup security.

 

[Ally]

This is an option but hiding columns will of course mean that the users won't be able to view them for reference.

 

[AncientOne]

No, I meant hide the tables, so they couldn't be edited and use a form instead,,,

 

[Ally]

Oops sorry!