How to set a limit to the record number

G

Guest

Hi
I would like to prevent a sample data base from storing in a table more
records than a maximum number. Do you know how?
Thanks in advance
GL
 
A

Arvin Meyer [MVP]

Use an autonumber as the primary key. Set a validation rule to the maximum
number of records. Like:

<=30

Secure the database and give no permissions on the tables except through
OwnerAccess queries. In the above case, no more than 30 records can be
entered.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Maximum record size and maximum number of records 3
About Access limits 15
How to protect an evaluation sample 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Data entry Form - confused and lost 9
Record or Form editing control 1
Update query error: "Operation must use an updateable query." 3
Realtionships and auto creating records. 3

Top