Securing primary key in an access form

[DvZ]

Hi
I am running a small network databse, but find it problematic that any of
the users can change the primary key. This often happen when they search for
a new record. Are there any way to secure or password protect entry in the
primary key field.
I have tried to lock the field, but if I do this the other network users are
unable to access records in the database.
Please help

 

[Rick Brandt]

Hi
I am running a small network databse, but find it problematic that
any of the users can change the primary key. This often happen when
they search for a new record. Are there any way to secure or password
protect entry in the primary key field.
I have tried to lock the field, but if I do this the other network
users are unable to access records in the database.
Please help

How exactly did you "lock the field"? If what you mean is that you set the
Locked property of the form control to True there is no way that would
affect users ability to access records. Can you explain what you mean by
that?

 

[Noëlla Gabriël]

Hi there,

I found the easiest way to "protect" a PK is to use an autonumber field as
PK. Always unique, always filled in and the users can't change it. I even
make sure the end users never see the PK field, so they can't start a
discussion about it.
After all the only thing the PK field has to do is define the record in an
unique way so it's possible to establish relationships.