Overflow (Error when running a query)

  • Thread starter Thread starter WaterBrook
  • Start date Start date
W

WaterBrook

I have a very basic query where I'm pulling data from a
huge table, and calculating a field based on two others in
the query, it summarizes the data perfectly. When I try
to add criteria in the query for the calculated field
(i.e. <1.5) the query fails and gives me an error message
that simply says "Overflow".

Does anyone know what the error message "Overflow" means,
and does anyone know how to work around it?
 
It is probably a Stack Overflow. It is a portion of memory used by a program
for temporary storage of data. I have seen this sort of problem fixed by
getting the most recent service pack for Jet. For Jet 4 (Access 2000 and
newer) it should be available at http://windowsupadte.microsoft.com. You can
also find it here:

http://support.microsoft.com/default.aspx?scid=kb;en-us;239114&Product=acc2002
and for Jet 3.51 (Access 97)
http://support.microsoft.com/default.aspx?scid=kb;en-us;172733&Product=acc97
 
Back
Top