Discussion Locked

Limiting Records in a table

0 helpful

2 replies

by devmann Sep 20, 2002 last reply Sep 22, 2002

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

How do I restrict the amount of records in an Access table.

2 replies

You can create a unique Index on an Integer or Long Integer field (or even an Autonumber) and use a Field Validation of

>0 AND <= 100

Thanks.... Greatly appreciated

This discussion is closed to new replies.