Is it possible to allow only one row in an Access table?
A Allen Browne Jun 20, 2008 #2 Create a table with a Number field that has these properties in the lower pane of table design: Default Value 1 Validation Rule: 1 Mark this field as the primary key. Add whatever other field you need.
Create a table with a Number field that has these properties in the lower pane of table design: Default Value 1 Validation Rule: 1 Mark this field as the primary key. Add whatever other field you need.