Limite the number of lines

[Eric Plante]

Not sure it's the right group for this so I appology in advance if I
mistaken.

I'd like to create a table with a fix number of rows(3 in my case) so the
user can't add anymore rows, is it possible to do it?

thanks

 

[Eric Plante]

I forgot to say that I am using access 97.

 

[John Vinson]

Not sure it's the right group for this so I appology in advance if I
mistaken.

I'd like to create a table with a fix number of rows(3 in my case) so the
user can't add anymore rows, is it possible to do it?

One way to do so is to create an integer Primary Key field, with a
Validation Rule of

= 1 AND <= 3

You'll need to either trust your users not to open the table in design
view and change this rule, or else implement Access security to lock
them out.