You will need to use the owner password method that someone else mentioned too. Create this rule and then go into the sys_rules table and edit the rule and change it from your autonumcol < 100 to count (*) < 100 and then it won't matter what the autonum value is and will always work.
You will need the security turned on and running the app w/ a user other than the owner, otherwise they could just turn off the rules, or change the rules. Troy -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of J.M. GRATIAS Sent: Wednesday, September 24, 2003 2:26 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Record Limit for Demo Troy : > An easy way to do it would be to put an autonumbered field in the table and then build a rule where the value in that field has to be less than what you want the limet to be. < Clever and very simple .... but this will not work if user is able to delete and recreate rows in the table without exceding the limit. J.M. GRATIAS, Logimatique
