how to limit maximum records in an access table?

W

Wee

I have a small Access 2002 DB with two tables. I want to limit the max
number of records in one of the tables to say 10 records regardless. i don't
want to write code to count the number of records. Any table property I can
set for this purpose?

Thanks
Wee.
 
A

aaron.kempf

you should use ACCESS DATA PROJECTS.. this has this functionality built
in and it ROCKS!!!
 
L

Larry Linson

you should use ACCESS DATA
PROJECTS.. this has this functionality built
in and it ROCKS!!!
Click to expand...

Your posts would be much more credible if you backed up your promotional
puffery with some how-to information.

Larry Linson
Microsoft Access MVP
 
A

aaron.kempf

ADP has this little recordcount selector on it in datasheet view

you can either do the clientside recordcount limiter; or you can do the


Select Top 10 * from sysobjects where name like '%happysproc%'
 
N

Norman Yuan

???, what are you talking about? The original post was about Access DB, not
SQL Server/MSDE, it has nothing to do with ADP.
 
Top