[dba-SQLServer] Re: Update query through Access ADP

Robert,

I now see two separate places where that sort of thing can be done:

1) Under Tools | Options | Advanced | Client-server settings, I can
change the 'Default max records' to some huge number, like a billion.

2) In the query's properties under View | Top, I can enter the
percentage of rows to return. It's set at 10% as a default.

Thank you. I should have looked further before posting the question.

Steve Erbach

P.S. Has anyone offered you Gmail address yet? If not, let me be the
first. I have a bunch of "invitations" to hand out, if you'd care for
one. I've been very happy with it overall.


On Fri, 11 Mar 2005 08:06:33 -0600, Robert L. Stewart
<rl_stewart at highstream.net> wrote:
> Steve,
> 
> There is a property of the query where you can set the number of rows it
> returns.  The default is 10,000.  You just need to change it to 1,000,000
> so that you will always get all of them.
> 
> Robert