Limiting records in a table

[Junior]

Acc2K
I have a lookup table and want to limit the possible records to <=10
entries.
How/where would i code the table to set this limitation?
thanks

 

[Duane Hookom]

If I understand correctly, you want to limit the number of records in a
table. About the only way you can do this is to use forms for all data
entry. This would allow you to run code to set the Allow Additions property
based on the number of records in the table.

 

[John Vinson]

Acc2K
I have a lookup table and want to limit the possible records to <=10
entries.
How/where would i code the table to set this limitation?
thanks

One sneaky way to do this is to include an Integer Primary Key, with a
validation rule of

 

[TC]

One sneaky way to do this is to include an Integer Primary Key, with a
validation rule of

Neat!

TC

 

[Junior]

thank you

One sneaky way to do this is to include an Integer Primary Key, with a
validation rule of

 

[John Vinson]

Neat!

TC

Sufficiently clever and determined users can get around this of
course. But it's a quick, dirty and effective way to do this kind of
limit!

 

[TC]

Sufficiently clever and determined users can get around this of
course. But it's a quick, dirty and effective way to do this kind of
limit!

Ok, I'll bite! How would they get around that? (without removing the rule,
of course)

TC

 

[TC]

oh... that's what I meant. Breaking your database security, or
otherwise getting to table design view, and removing the rule. Or
renaming the table and creating their own unrestricted table of the
same name.

Ok, I thought you maybe had a sneaky: "Get stuffed, PK!" trick

TC
(off for the day)

 

[John Vinson]

Ok, I'll bite! How would they get around that? (without removing the rule,
of course)

oh... that's what I meant. Breaking your database security, or
otherwise getting to table design view, and removing the rule. Or
renaming the table and creating their own unrestricted table of the
same name.

With Access security, it's about as good as you can get... but Access
security can be broken, and then the breaker has pretty much free
rein.