Setting Maximum # of Records

[BeallDon]

How can I set the maximum # of records in a table? I have a table and I only want the user to be able to create 70 records maximum.

 

[jrbarnett]

You will need to control and validate this through your user input forms and restrict access to the tables directly.
There is no way to restrict this at the table level.

John

 

[BeallDon]

ok, but how do I "control and validate this through my user input forms and restrict access to the tables directly"??

 

[Remou]

You can create a bound form for data entry based on the relevant table. After that, there are a number of ways to control data entry, one that springs to mind is to disallow adding records (AllowAdditions) if the count (DCount) is equal to the number allowed.

 

[BeallDon]

thanks Remou. The DCount worked perfectly.