Overflow

[eacollie]

I am getting an "overflow" error (not numerical overflow) when running a form.

This error is only appearing on records that were added to the table after a certain date. If I run the form using older records from the same table, I don't get this error. I've tried a compact and repair, but it doesn't help.

Any suggestions of what may be happening here?

[ADezii]

I am getting an "overflow" error (not numerical overflow) when running a form.

This error is only appearing on records that were added to the table after a certain date. If I run the form using older records from the same table, I don't get this error. I've tried a compact and repair, but it doesn't help.

Any suggestions of what may be happening here?

How are Records being added to your Table?

[eacollie]

How are Records being added to your Table?

Through a form. However, this has worked for a long time without error.

[ADezii]

Through a form. However, this has worked for a long time without error.

Would you be willing and able to send the the Database as an E-Mail Attachment for me to have a look at? To be perfectly honest with you, this would seem to be a difficult problem to resolve with so little information to go on.

[eacollie]

Would you be willing and able to send the the Database as an E-Mail Attachment for me to have a look at? To be perfectly honest with you, this would seem to be a difficult problem to resolve with so little information to go on.

Yes, I agree. I'm trying to resolve the issue from a distance and nobody is "fessing up" to having made any changes...it's like looking for a needle in a haystack. Unfortunatly, I'm not allowed to send the data. I have the data and forms/reports separated and can send those. However, wouldn't it seem that the problem would be in the data, as it only happens with records added after a certain date?

[ADezii]

Yes, I agree. I'm trying to resolve the issue from a distance and nobody is "fessing up" to having made any changes...it's like looking for a needle in a haystack. Unfortunatly, I'm not allowed to send the data. I have the data and forms/reports separated and can send those. However, wouldn't it seem that the problem would be in the data, as it only happens with records added after a certain date?

Are the Data Types of the Fields being added in sync with the Data Types in the Table to which they are being added?

[missinglinq]

Obviously, you reached some sort of limit with the new records!

"I am getting an "overflow" error (not numerical overflow)"

What exactly do you mean by this? Is this Error 6 Overflow?

Usually when you get this type of error, in a long running program, it means that some type of running total has finally exceeded the limit of the datatype it's assigned to. A running total of clients served, for example, defined as an Integer in the Table Def, will run correctly for years, until the number of clients exceed
32767, the max for an Integer, and then bomb out.

[eacollie]

Obviously, you reached some sort of limit with the new records!

"I am getting an "overflow" error (not numerical overflow)"

What exactly do you mean by this? Is this Error 6 Overflow?

Usually when you get this type of error, in a long running program, it means that some type of running total has finally exceeded the limit of the datatype it's assigned to. A running total of clients served, for example, defined as an Integer in the Table Def, will run correctly for years, until the number of clients exceed
32767, the max for an Integer, and then bomb out.

There is no numerical code associated with the error message...just says "overflow."

The primary key for this table is a long integer and the value where it begins to generate this error is 32774.

Is there anything that can be done?

Thanks!

[eacollie]

Are the Data Types of the Fields being added in sync with the Data Types in the Table to which they are being added?

It doesn't matter whether I add a new record to the table directly or through a form; I still get an overflow error for any record added after a given date when using the form.

[eacollie]

I think I solved the problem....

In my form where I was picking up the primary key of the record, I had the variable defined as an integer. When I change the definition to Long, it picks up the value and doesn't "overflow."

Thanks for all the information.... I wouldn't even have thought to check this without you! Much thanks again!

[missinglinq]

Glad we could help!

Linq ;0)>