[AccessD] Number of 'OR's in queries - what's the limit?

Still looks like 99 in 2003

Ed Tesiny
EdTesiny at oasas.state.ny.us
 

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> Mark A Matte
> Sent: Tuesday, July 24, 2007 2:23 PM
> To: accessd at databaseadvisors.com
> Subject: Re: [AccessD] Number of 'OR's in queries - what's the limit?
> 
> I found it in A97 and A2002...search help for 
> 'Specifications'...in 97 its 
> query specs...and in 2002 its access specs...97 is 40...2002 is 99.
> 
> I don't have 2003 to look.
> 
> Good Luck,
> 
> Mark A. Matte
> 
> 
> >From: "Dan Waters" <dwaters at usinternet.com>
> >Reply-To: Access Developers discussion and problem 
> >solving<accessd at databaseadvisors.com>
> >To: "'Access Developers discussion and problem 
> >solving'"<accessd at databaseadvisors.com>
> >Subject: Re: [AccessD] Number of 'OR's in queries - what's the limit?
> >Date: Tue, 24 Jul 2007 12:31:31 -0500
> >
> >That's a good plan!  I was hoping to do a customer update 
> within the next
> >half hour though.
> >
> >I was hoping that someone had seen some documentation on 
> this.  The number
> >40 was documented 'somewhere' in Access help.
> >
> >-----Original Message-----
> >From: accessd-bounces at databaseadvisors.com
> >[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
> >Sent: Tuesday, July 24, 2007 12:13 PM
> >To: 'Access Developers discussion and problem solving'
> >Subject: Re: [AccessD] Number of 'OR's in queries - what's the limit?
> >
> >You could reasonably quickly set up a test to find out by building a 
> >dynamic
> >query, a string such as select PKID from tblX where (PKID=1 or PKID=2
> >or...).  Add 10 (or 100) at a time and see how far you get.
> >
> >
> >John W. Colby
> >Colby Consulting
> >www.ColbyConsulting.com
> >-----Original Message-----
> >From: accessd-bounces at databaseadvisors.com
> >[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
> >Sent: Tuesday, July 24, 2007 1:02 PM
> >To: 'Access Developers discussion and problem solving'
> >Subject: [AccessD] Number of 'OR's in queries - what's the limit?
> >
> >In Access 97, there was a limit of 40 OR words in a query.  
> There is a 
> >limit
> >in Access 2003, it's >250, but I don't know what it actually is.
> >
> >Does anyone know?
> >
> >Thanks!
> >Dan
> >
> >
> >
> >--
> >AccessD mailing list
> >AccessD at databaseadvisors.com
> >http://databaseadvisors.com/mailman/listinfo/accessd
> >Website: http://www.databaseadvisors.com
> >
> >--
> >AccessD mailing list
> >AccessD at databaseadvisors.com
> >http://databaseadvisors.com/mailman/listinfo/accessd
> >Website: http://www.databaseadvisors.com
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >--
> >AccessD mailing list
> >AccessD at databaseadvisors.com
> >http://databaseadvisors.com/mailman/listinfo/accessd
> >Website: http://www.databaseadvisors.com
> 
> _________________________________________________________________
> http://newlivehotmail.com
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>