Numeric overflow

G

Guest

I have a 2003 db from which I run a query that finds data in a text field and
places it in a text field in another table. The query works find the first
time, the second time it is run you get a numeric overflow. If you run the
compact/repair, it will run once again. It would be difficult to diagnose
with such limited information, but perhaps some has thoughts on what to look
for.
Thanks,
Warren
 
O

OfficeDev18 via AccessMonster.com

Hi, Warren,

Look at the two tables in Design mode. Are the lengths of the two text fields
the same lengths? What about other paramters? This could be the cause.
 
G

Guest

OfficeDev18 via AccessMonster.com said:
Hi, Warren,

Look at the two tables in Design mode. Are the lengths of the two text fields
the same lengths? What about other paramters? This could be the cause.

Warren wrote:Thanks. I will check that out. Warren

--
Sam


Message posted via AccessMonster.com
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Numeric Field Overflow 1
Numeric Field Overflow Error 5
Numeric Field Overflow when appending date - how to convert it to text 1
Why can't I run my query multiple times? 1
The Numeric Field Overflow error with linked tables 2
Numeric field overflow error on date field 3
Using query to make a table 3
Query only runs in Design Mode 1

Top