RE: Access 2007 - Overflow + error 2950 when running a macro

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Donatella,

Is the error a stack overflow or a numeric overflow? Usually when a
query has trouble it is due either to the data with which it is trying to
deal or it is too complicated. Is the data that does not work larger in
quantity? Unfortunately, to my knowledge, there is no debugging tool for SQL
statements. You usually have to look at the data that is causing trouble
and/or start breaking the statement into smaller parts to try to isolate
where the trouble is. My guess is that the data may be the issue.
Especially if succeeding day's data works again. Have you had the chance to
test that? You could try breaking the data into half and then quarters; see
if that helps.

Good Luck,

Clifford Bass

"Donberti" wrote:

Hello Clifford,

thank you. Through your tip (to use Navigator) I could restrict the query
that is not working (and the macro calls up a table which is created by that
query).

What I did so far is to compare the sql statements when I run access on both
.csv files (the one working and the one with problems). No sign of errors,
which is quite odd. I will check with the guy who wrote these statements, not
diving in these waters.. the statements are quite long (and difficult to me).

It would be helpful though to know a debugging tool for access. It would be
great if you know about any. I tried a button in access ( step by step in
designer view I guess) but it does not show what is causing the problem, I
think this can be done with VBA but it would be for me like writing in
Japanese.

Best regards and have a nice day,
Donatella

Thank you anyway. Let's see what happens,
Best regards
Donatella
.

Quantcast