Francisco H Tapia
my.lists at verizon.net
Wed Jul 30 11:38:14 CDT 2003
In the Options > Advance Tab you have a Row Limit for the Client-server settings (Default Max Rows) The code way to get to that is to set it as Application.SetOption "Row Limit", 0 I had to go to the MSDN.microsoft.com site to find that answer as the "named options" list is wrong in the Access Help, not a little wrong, all the way wrong :) Whoo hoo, way to keep us guessing Uncle Bill... ;o) -Francisco http://rcm.netfirms.com On Wednesday, July 30, 2003 10:31 AM [GMT-8], Nicholson, Karen <knicholson at gpsx.net> wrote: : Do you mean on the options tab in Microsoft Access, if you set the : "dont display lists where more than this number of records read" to : 0, it takes off the limit? : : -----Original Message----- : From: Nicholson, Karen [mailto:knicholson at gpsx.net] : Sent: Wednesday, July 30, 2003 1:27 PM : To: dba-sqlserver at databaseadvisors.com : Subject: RE: [dba-SQLServer]Re: Sproc runs and then it doesn't : : : Oh my, that is intuitive! : : -----Original Message----- : From: Francisco H Tapia [mailto:my.lists at verizon.net] : Sent: Wednesday, July 30, 2003 12:26 PM : To: dba-sqlserver at databaseadvisors.com : Subject: Re: [dba-SQLServer]Re: Sproc runs and then it doesn't : : : Thanks Doris :) : : -Francisco : http://rcm.netfirms.com : : On Tuesday, July 29, 2003 1:53 PM [GMT-8], : Mike and Doris Manning <mikedorism at ntelos.net> wrote: : :: If you set the default to 0, it will always return all the records. :: :: Doris Manning :: Database Administrator :: Hargrove Inc. :: www.hargroveinc.com :: :: :: -----Original Message----- :: From: dba-sqlserver-bounces at databaseadvisors.com :: [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of :: Francisco H Tapia :: Sent: Tuesday, July 29, 2003 2:55 PM :: To: dba-sqlserver at databaseadvisors.com :: Cc: SQL Server 2k List :: Subject: [dba-SQLServer]Re: Sproc runs and then it doesn't :: :: :: My co-worker found an option in Access for the amount of records to :: limit the return to, in Access it is defaulted to 10k, for my home :: version it is set to this limit as well as here at work, but at home :: the results are as expected, at work I had to modify this result to > :: 10,000 records, I chose as a test 100,000,000 which yields the :: correct results. :: : <snip> : : : _______________________________________________ : dba-SQLServer mailing list : dba-SQLServer at databaseadvisors.com : http://databaseadvisors.com/mailman/listinfo/dba-sqlserver : http://www.databaseadvisors.com : _______________________________________________ : dba-SQLServer mailing list : dba-SQLServer at databaseadvisors.com : http://databaseadvisors.com/mailman/listinfo/dba-sqlserver : http://www.databaseadvisors.com : _______________________________________________ : dba-SQLServer mailing list : dba-SQLServer at databaseadvisors.com : http://databaseadvisors.com/mailman/listinfo/dba-sqlserver : http://www.databaseadvisors.com