Overflow

[gc]

I got "6: Overflow" message when I run a code:

SQL = "SELECT * FROM [tblPatients_All] ORDER BY PtID, SOC, DCDate;"
Set rstPt_Init = db.OpenRecordset(SQL, dbOpenSnapshot)

The tblPatients_All has 34400 records.
I checked the data for each field and didn't find any data is out of field range.

I have another similar two tables which have same fields and datatypes. When I run the same code I didn't get any problem. The number of records are 2200 and 32200. Indeed, I just merge the data of these two tables into tblPatients_All.

I can't figure out why this happened?

Please help! Any idea is greatly appreciated!

George

p.s. the data is from a text file. I try to import the text file into an SQL servser database. it stopped. But if the number of records is less than 30000. It was fine. Is there a limit for the number of records?

 

[jimmythegeek]

Every overflow error I have ever gotten, is because I was trying to assign a number larger than 32,767 to an integer data type. An integer data type has that limitation, so I had to change the data type to a Long Integer. Don't know if this is the problem, but worth a look.

Either a variable, or a field in a table. Jim Lunde
compugeeks@hotmail.com
We all agree your theory is crazy, but is it crazy enough?

 

[gc]

Jim,
Thanks for your response.
My number field dataypes are Long or Single. Is any other reason to cause overflow? How about text and date field?
George

 

[jimmythegeek]

Have you checked the size of all your text fields and made sure that the data being imported is not larger than the character limitations? That is the only thing I can think of. I would also try the Microsoft Knowledge Base. Do a search on Overflow.

http://support.microsoft.com/default.aspx?

Jim Lunde
compugeeks@hotmail.com
We all agree your theory is crazy, but is it crazy enough?