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

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Clifford,

The error was caused by a single field in the extract I load in Access
(which is quite big). In this field there is the combination of
number+E+number. In one of the table there is a val function which should run
and read the field as letter BUT "E" is also a math function (did not
really know) - the val function has a problem with this "E". This was causing
the overflow. So you were right.

I am checking in the next day what is happening. Of course I would have
never found it. I got help on this. I think I'll go for a brandy now.

Sorry if I did not answer your previous post. Was kind of stressed.
Best regards and have a good day,
Donatella
--


"Clifford Bass" wrote:

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
.

Relevant Pages

  • Re: sorting data on a continous subform
    ... >>Sort Ascending is the default and has nothing to do with any ... >>until we get rid of the overflow problem. ... >>and reun the query against just a few records. ... >>the record that's causing the overflow. ...
    (microsoft.public.access.formscoding)
  • Re: sorting data on a continous subform
    ... > I meant when you look in the design view of the query - the expressions have ... >ascending in the sort row and that is what seems to cause the overflow. ... Those multiple properties in a single record are not causing ...
    (microsoft.public.access.formscoding)
  • Re: "Overflow" error in an Access 20003 query
    ... fields to Double and the query will now run. ... "Jason Lepack" wrote: ... causing the problem then. ... And I have never seen an "Overflow" error in any Access application I have ...
    (microsoft.public.access.queries)
  • Re: Special Character #
    ... I'm trying to query a desc field that has '' in it. ... It looks like it's the '#' symbol that's causing the trouble. ... John W. Vinson [MVP] ...
    (microsoft.public.access.queries)
  • Re: Special Character #
    ... Vice versa if it is always at the beginning. ... I'm trying to query a desc field that has '' in it. ... It looks like it's the '#' symbol that's causing the trouble. ...
    (microsoft.public.access.queries)