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

Query Limit in Access

P: 1
Hi, I was wondering if anyone out there could help me. I've developed a database in Access which pretty much consists of a bunch of queries which churns data from linked tables and then produces a bunch of output tables whcih I then use to base my forms on...which in turn are used to generate a report (subforms etc)!

I know there is a limit or a point you can hit in MS Access where if wont run any more queries but I thought I got rid of that problem by running the queries to output tables and then running the foms (and in turn the report) off the output tables rather than the queries. Yet I have a union query which I've just updated and it wont work. I'm using standard logic to build the union query and its a very similar query to others I already have working in the database (its just using a different source data/linked table) and yet it wont generate the correct answer.

Any ideas on why I'm hitting the wall here in Access?
Jun 14 '07 #1
Share this Question
Share on Google+
1 Reply


puppydogbuddy
Expert 100+
P: 1,923
Hi, I was wondering if anyone out there could help me. I've developed a database in Access which pretty much consists of a bunch of queries which churns data from linked tables and then produces a bunch of output tables whcih I then use to base my forms on...which in turn are used to generate a report (subforms etc)!

I know there is a limit or a point you can hit in MS Access where if wont run any more queries but I thought I got rid of that problem by running the queries to output tables and then running the foms (and in turn the report) off the output tables rather than the queries. Yet I have a union query which I've just updated and it wont work. I'm using standard logic to build the union query and its a very similar query to others I already have working in the database (its just using a different source data/linked table) and yet it wont generate the correct answer.

Any ideas on why I'm hitting the wall here in Access?
Can't tell whether you are running into Access Limitations based on the info you provided. See the link below for Access Specs and Limits that you can use to make your own determination.

http://www.databasedev.co.uk/access_specifications.html
Jun 15 '07 #2

Post your reply

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