Creating a sample database

J

Jim Z.

I would like to make a sample database that limits the
amount of entries. How can this be acomplished.
 
J

John Vinson

I would like to make a sample database that limits the
amount of entries. How can this be acomplished.

One sneaky way is to have an Autonumber or (Long) Integer primary key
with a validation rule
0 AND <= 100

to limit the table to 100 entries. Of course you need to ensure that
the user can't open the table in design view and change the rule!
 
J

Jeff Conrad

Well hey, even "I" could do that!
Thanks for the tip John, I might use this.

Jeff Conrad
Bend, Oregon
 

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

sample database template 1
Limiting the amount of records 1
too many tables? 3
HR sample access database 4
Searching and Linq 2
Excel How to create a stacked bar graph 0
sample subscription database 2
PPM database sample 5

Top