J John Vinson Jan 22, 2007 #2 On Sun, 21 Jan 2007 19:13:32 -0800, W Spears <W Is there any way to limit the number of entries in a table? Click to expand... One way would be to have an Integer primary key, with a validation rule 0 AND <= 100 Click to expand... Best not to use an Autonumber if you want to be able to reenter records that have been deleted. Of course, you must use database security to prevent someone from simply removing this validation rule. John W. Vinson[MVP]
On Sun, 21 Jan 2007 19:13:32 -0800, W Spears <W Is there any way to limit the number of entries in a table? Click to expand... One way would be to have an Integer primary key, with a validation rule 0 AND <= 100 Click to expand... Best not to use an Autonumber if you want to be able to reenter records that have been deleted. Of course, you must use database security to prevent someone from simply removing this validation rule. John W. Vinson[MVP]
