i am using visual studio 2010 with vb environment, i have a windows form app that connects to a local sql express database, i am wanting to limit the amount of records that can be added to a table to 100, how would i go about it, i am using the standard navigation buttons to add records.

the table has a id field that is autogenerated and auto increment of 1

thanks.