Max number of queries

[Tony Wainwright]

Hi Guys

I am building a Access XP application which will include about 800 queries.
What is the maximum number of queries that AXP supports?

Tony

 

[Brett Collings [429338]]

This is from A97's Help .... (keyword "Limits"). Unfortunately, it's
much harder to find this stuff in A2K + Help. In A2003 this keyword
returns nothing of value for this enquiry ..... grrrr. Ahhh found it
under A2003 keywords "Access Specifications". Same values with the
exception of second to last one.

Query specifications
==============
Attribute Maximum
-------- --------
Number of enforced relationships 32 per table minus the number
of indexes that are on
the table for fields or
combinations of fields
that are not involved in relationships
Number of tables in a query 32
Number of fields in a recordset 255
Recordset size 1 gigabyte
Sort limit 255 characters in one or more fields
Number of levels of nested queries 50
Number of characters in a cell in the query design grid 1,024
Number of characters for a parameter in a parameter query 255
Number of ANDs in a WHERE or HAVING clause 40 (A2003 = 99)
Number of characters in an SQL statement approximately 64,000

Brett

Hi Guys

I am building a Access XP application which will include about 800 queries.
What is the maximum number of queries that AXP supports?

Tony

Cheers,
Brett

 

[Rick B]

Yikes! 800 queries? Could you not use parameters to run one query multiple
ways? Is your design normalized?

Rick B

 

[Brett Collings [429338]]

Yikes! 800 queries? Could you not use parameters to run one query multiple
ways? Is your design normalized?

Rick B

Yes Rick, I didn't even go *there*

There is something seriously wrong with the structure but I didn't
want to ask because I might have got asked to help sort it

Brett



Cheers,
Brett

 

[Tony]

Just got the number of queries down to a quarter of that. No the data is
not normalised - application uses an Excel spreadsheet for raw data. Some
normalisation is done during an import routine. Occasionally the best way
is NOT to get bogged down in such things.

The application requires 128 reports which can now be generated from those
200ish queries. Thanks for the answers - Brett, I wasn't asking for the
application to be normalised as apart from those area's that are done in the
import routine it is at 3NF.

Cheers Tony