By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,828 Members | 2,241 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,828 IT Pros & Developers. It's quick & easy.

Set Default Max Records in VBA

P: n/a
Is there a way to set Max Default Records in VBA code?
Application.SetOption ???, 0
lq
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Nov 12 '05 #2

P: n/a
Access>Tools>Options>Advanced>Client-Server Settings>Default max records.
I'm trying to set this through code to unlimited.
lq
"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message news:<O4********************@twister01.bloor.is.ne t.cable.rogers.com>...
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

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.