All my systems currently use Access as a front end
Default for SQL 2000 is to return 10K rows
I'm not sure how you get round this (BOL maybe), but maybe you could try
SELECT TOP 100 PERCENT ..
Alec Wood
-----Original Message-----
From: Ligda John
[mailto:mssqldba-ezmlmshield-x37180155.[Email address protected]
Sent: 28 March 2008 17:57
To: LazyDBA Discussion
Subject: Ms Access Project question (sorry)
Business analyst using MS Access just asked my why he only gets 10K
record sets returns. IDK.... I don't use access. He has it set up as
a 'project' which means it interacts directly with SQL 2000. Anyone
else deal with coworkers who use this program?
John Arthur Ligda
Hall Capital Partners LLC
One Maritime Plaza, Suite 500
San Francisco, CA 94111
(415) 277-2692
(415) 288-4694(fax)
[Email address protected]
--
DISCLAIMER
Confidentiality Note: This e-mail is intended only for the person or entity
to
which it is addressed and may contain information that is privileged,
confidential or otherwise protected from disclosure. Dissemination,
distribution or copying of this e-mail or the information herein by anyone
other than the intended recipient, or an employee or agent responsible for
delivering the message to the intended recipient, is prohibited. If you have
received this e-mail in error, please notify us immediately (telephone
415-288-0544 or e-mail [Email address protected] and destroy the original
message and all copies.
Hall Capital Partners LLC reserves the right to monitor and review the
content
of all e-mail communications sent and/or received by its employees.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
No virus found in this incoming message.
Checked by AVG.
Version: 7.5.519 / Virus Database: 269.22.1/1350 - Release Date: 30/03/2008
12:32
No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.519 / Virus Database: 269.22.1/1350 - Release Date: 30/03/2008
12:32
MS Sql Server LazyDBA home page