Protecting data in primary key from being changed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've created a database and I want to make sure that the data in the primary
key in one of the main tables cannot be changed accidentally. How can I
easily protect this field from being changed once data has been entered? Any
ideas??
 
If it is an autonumber field, you can just disable any controls showing the
ID on all forms. Is this what you mean?

Doug
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Same record/Primary key in multiple tables 0
primary key - concatenated or autonumber? 6
Update primary Key. 1
Primary Keys yes or no? 8
How can I Manually Change Access Primary Key ID Fields ? 2
Primary key help 2
Duplicate values in the index, primary key, or relationship messag 2
Primary Key new field 2

Back
Top