Restrict a table to a single record

=========
QUESTION
———
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?

 

=========
ANSWER
———
Use a required field, like the Primary Key (but DO NOT set to AutoNumber)
Set it to:
Default Value: 1
Validation Rule: =1
Required: Yes
Indexed: Yes (No Duplicates)

 

=========
EXAMPLES
———

 

=========
APPLIES TO / KEY WORDS
———
Microsoft Access
Unique Records
Limit to a single record
Limit a table

 

=========
REF
———
http://social.msdn.microsoft.com/Forums/en-US/accessdev/thread/4c5b29f6-15cd-4dab-858a-57c90569b97c/

 


http://www.anysitesupport.com/restrict-a-table-to-a-single-record/
http://anySiteHosting.com

By | 2017-12-01T23:47:35+00:00 October 28th, 2011|Access, Computers, Documentation, Microsoft|0 Comments