Limiting the table?

[Mario]

How do you limit the table so it could hold only 1 or 2 records?

 

[Elwin]

I did this by setting the validation rule property of my
primary key field to =1.

By definition, my primary key MUST be unique. By design,
it MUST be equal to one. Voila! Only one record possible
in the table. Good luck.

 

[John Vinson]

How do you limit the table so it could hold only 1 or 2 records?

One good way is to have an integer Primary Key, with a validation rule
of

=1

to limit it to one record; or

IN (1, 2)

to limit it to two.