System Resource Exceeded

[dodge20]

I have Access2002 on windows xp
I have a bunch of queries that work fine. Each query builds off the last query. Then I try to get a sum of 2 final queries and I get:

odbc microsoft acces driver System Resource Exceeded

anybody no why this is? I have compacted and repaired the database. Imported the tables/queries into a new database. I don't know why I am getting this. Have I reached access' limits?

Here is the query if interested

SELECT (r.TotalPoints + b.TotalPoints)
FROM BonusTotals b, roundtotals r
where r.BRACKETID = b.BRACKETID



Dodge20

 

[willir]

Dodge20

Very odd.

I assume you are using ODBC to link to the tables BonusTotals and RoundTotals - correct? As a work around, can you use a Stored Procedure to run the query?

Next...

I have a bunch of queries that work fine. Each query builds off the last query. Then I try to get a sum of 2 final queries

Do you mean the above SELECT query is nested within other queries? If so, consider simplifying - you may have reached a limit somewhere?

Also, the target tables -- are they large, lots of records??

Next...
Consider using DAO or ADO code to create a RecordSet and loop through to find your values -- it will be a lot slower but may be kinder on resoruces.

Richard

 

[dodge20]

Yes I am using ODBC to link the tables. Will it help to use relationships between queries? Right now I am only doing it through the tables. And since this is going to be entered from a website, I had to use some normalization union queries in order to create a table in the format I wanted. So actually there are queries that I use as tables. Can I make a relationship between a query and a table?

So because it is coming from the web(asp) I am not sure how to get a stored procedure to work on an asp page.
The number of records is very small at this point, because I am still in the testing phase, so each table only has a few records.

Dodge20

 

[dodge20]

I was able to work around this error. I had too many union queries, and adjusted my table structure. It looks like there is a limit in acces on queries. Now I just need to figure out how to make the inserting work from my webpage on the updated tables structure.


Dodge20