You mean you're trying to limit how many rows may be stored in a table?
There's no way that I'm aware of.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)
"Lauren Quantrell" <la*************@hotmail.com> wrote in message
news:47**************************@posting.google.c om...
Is there a way to set Max Default Records in VBA code?
Application.SetOption ???, 0
lq