Lock table default values

[InFlight]

Hi
I have a table that i need to lock the default value from being changed in table edit view

 

[MajP]

This is a really bizarre question. The user can have full access to your table design, but the thing you are most worried about is the default value on a field? No that cannot be done.

 

[InFlight]

Even if i can lock the table

 

[GinaWhipp]

Umm, no you can't *lock* that. Why are you giving your Users the ability to get to table design view? Why aren't you using Forms? Maybe you need to tell us a little more of what you are doing or trying to do because something seems off here.

 

[isladogs]

Adding to the previous comments here....
If this field should never change from its default value (which you implied by talk of 'locking the table), then it should be defined as a constant and removed from the table.

EDIT
Just noticed your table doesn't have a primary key field. This should be done so records cannot be duplicated. Also, update queries will not work on table with no PK field.

 

[jdraw]

InFlight,

Perhaps if readers understood the issue and why users would have access to design view, then there my be some feasible options for how to achieve this.