If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Max number of queries
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 |
#2
|
|||
|
|||
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 On Tue, 26 Oct 2004 10:35:54 +0100, "Tony Wainwright" wrote: 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 ---------------------------------------------- Be adventurous, be bold, be careful, be a star ---------------------------------------------- Brett Collings Business & Systems Analyst Management Information Systems Developer |
#3
|
|||
|
|||
Yikes! 800 queries? Could you not use parameters to run one query multiple
ways? Is your design normalized? Rick B "Tony Wainwright" wrote in message ... 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 |
#4
|
|||
|
|||
On Tue, 26 Oct 2004 11:48:04 -0500, "Rick B" Anonymous wrote:
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 "Tony Wainwright" wrote in message ... 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 ---------------------------------------------- Be adventurous, be bold, be careful, be a star ---------------------------------------------- Brett Collings Business & Systems Analyst Management Information Systems Developer |
#5
|
|||
|
|||
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 "Brett Collings [429338]" wrote in message news On Tue, 26 Oct 2004 11:48:04 -0500, "Rick B" Anonymous wrote: 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 "Tony Wainwright" wrote in message ... 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 ---------------------------------------------- Be adventurous, be bold, be careful, be a star ---------------------------------------------- Brett Collings Business & Systems Analyst Management Information Systems Developer |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Number of Mondays in month | Michael Noblet | Setting Up & Running Reports | 3 | July 28th, 2004 10:41 PM |
Restart Autonumber | Traci | New Users | 22 | July 21st, 2004 01:10 AM |
Update query by 1/2 entered number | Eb1mom | Running & Setting Up Queries | 2 | July 9th, 2004 02:07 AM |
Job Number Match function??????? | Russ | Worksheet Functions | 3 | April 19th, 2004 06:51 PM |
Excel- Inserting a varying number of rows | Ken Wright | Worksheet Functions | 1 | March 20th, 2004 10:20 PM |