Lock table default values (1 Viewer)
- Thread starter InFlight
- Start date
MajP
You've got your good things, and you've got mine.
- Local time
- Today, 00:41
- Joined
- May 21, 2018
- Messages
- 8,525
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.
GinaWhipp
AWF VIP
- Local time
- Today, 00:41
- Joined
- Jun 21, 2011
- Messages
- 5,900
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
MVP / VIP
- Local time
- Today, 05:41
- Joined
- Jan 14, 2017
- Messages
- 18,209
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.
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.
Last edited:
