By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,949 Members | 2,038 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,949 IT Pros & Developers. It's quick & easy.

the data in my report and forms seem to be to large.

P: 55
Is there a workaround I can use to keep all the data, but enlarge the form and/or report?

I am running Access 2003
Jul 20 '07 #1
Share this Question
Share on Google+
11 Replies


Rabbit
Expert Mod 10K+
P: 12,366
What do you mean by enlaring the form?
What do you mean by keeping the data? Are you saying the data is disappearing?
Jul 20 '07 #2

P: 55
When I try to build a form or a report from a query the data is to large. Can you have too many data fields, which can cause the database to become unresponsive?
Jul 20 '07 #3

Rabbit
Expert Mod 10K+
P: 12,366
When I try to build a form or a report from a query the data is to large. Can you have too many data fields, which can cause the database to become unresponsive?
Yes, that could be one reason, although the database can become unresponsive for a number of reasons such as a complex expression or a non-cartesian join. How many fields and records are we talking about?
Jul 20 '07 #4

P: 55
Yes, that could be one reason, although the database can become unresponsive for a number of reasons such as a complex expression or a non-cartesian join. How many fields and records are we talking about?

18 Fields. These 18 fields are summaries of about 30 other queries.
Jul 20 '07 #5

Rabbit
Expert Mod 10K+
P: 12,366
18 fields are well within the abilities of access. Your problem is most likely the 30 other queries. Each of those queries have to run everytime you run your one query. And a problem with any one of those queries can cause a hang up not to mention it takes a while to run 30 queries in the first place.

A few reasons could be:
1) A non-cartesian join
2) A complex expression
3) A loop in the queries

I don't know why you need so many queries because I don't know what you're trying to query but you're most likely not using the most efficient queries.
Jul 20 '07 #6

P: 55
18 fields are well within the abilities of access. Your problem is most likely the 30 other queries. Each of those queries have to run everytime you run your one query. And a problem with any one of those queries can cause a hang up not to mention it takes a while to run 30 queries in the first place.

A few reasons could be:
1) A non-cartesian join
2) A complex expression
3) A loop in the queries

I don't know why you need so many queries because I don't know what you're trying to query but you're most likely not using the most efficient queries.




I'm using basic queries. Would a make-table or some other form of queries work better?
Jul 20 '07 #7

Rabbit
Expert Mod 10K+
P: 12,366
A make-table query would take longer. It would have to create 30 tables from your queries before running your query.

As for a different type of query, I can't say because I don't know what you're trying to query.
Jul 20 '07 #8

P: 55
A make-table query would take longer. It would have to create 30 tables from your queries before running your query.

As for a different type of query, I can't say because I don't know what you're trying to query.
Market Valuations

Transactions...
Jul 20 '07 #9

Rabbit
Expert Mod 10K+
P: 12,366
Market Valuations

Transactions...
I would need to know more than that.
I would need to know your tables, the fields in those tables, the relationships between the tables, and what it is that you're trying to accomplish with the query.
Jul 20 '07 #10

P: 55
I would need to know more than that.
I would need to know your tables, the fields in those tables, the relationships between the tables, and what it is that you're trying to accomplish with the query.

Rabbit,

I will figure something out. There are really too many select quueries. PErhaps I can cross reference some of them. Thanks for your help. Sorry if my information was too vague.

My info is sensitive.
Jul 20 '07 #11

Rabbit
Expert Mod 10K+
P: 12,366
Rabbit,

I will figure something out. There are really too many select quueries. PErhaps I can cross reference some of them. Thanks for your help. Sorry if my information was too vague.

My info is sensitive.
I'm not asking for the info, just what info you're collecting.
Jul 20 '07 #12

Post your reply

Sign in to post your reply or Sign up for a free account.