Access 97 "Overflow" message

[DSKwaj]

I just appended 171 additional records to a table.

I then went to run a query that uses this table and now get an "overflow" message and the query returns nothing.

If I remove the 171 records the query works as intended.

Anyone have an idea where I should start looking for a resolution to this problem???

Thanks

 

[mac318]

If you have a counter which decrements with each record, you may have dim'd it improperly. For example, if you dim the counter as byte, it will overflow on the 256th record.

mac

 

[GingerR]

what is the exact error message?