I use a table called Parms in my database to store application specific parameters.
If a user accidentally added a record to this table, instead of simply editing the single record containing the appropriate values, it would cause major issues for the application.
Is there a way to restrict a table to contain only a SINGLE record in Microsoft Access?
Use a required field, like the Primary Key (but DO NOT set to AutoNumber)
Set it to:
Default Value: 1
Validation Rule: =1
Indexed: Yes (No Duplicates)
APPLIES TO / KEY WORDS
Limit to a single record
Limit a table