Hello,

I am trying to limit the number of records allowed in a
table.  The best solution I have found is to create a
DELETE Query that deletes any records that go beyond the
specified limit.

This solution works okay.  It allows the user to add
records, but then deletes them when they perform some
other action that triggers the DELETE Query.

Is there another/better way to set a limit on number of
records . . . possibly one that gives an error message
when they have exceeded the limit?

Any help would be greatly appreciated.  Thanks in
advance!!!  DV