Limiting the amount of records

  • Thread starter Thread starter John Z
  • Start date Start date
How does one limit the amount of records to a table in
creating a sample database.

One sneaky way is to use an Integer primary key with a validation rule
such as
0 AND <= 100

to limit the table to 100 records. You'll need to ensure that the
recipient can't get into table design view, but you'ld need that level
of control in any scheme.
 
Back
Top