record count

[Peter]

I have a customer who imported 38,345 records into a
table.
Upon openning the application he gets an overflow error.
What are the limitations regarding number of records
allowed. Do you think a compact and repair will solve the
problem.

Thanks for any help
Pete

 

[Ken Snell]

Chances are that there is a field in the table that is using a number
equivalent to the "record number" as its value, and that field is formatted
as Integer. 38,000 is too large for Integer; you must use Long Integer as
the data field format.

Or there is a query with a similar problem.....

Then again, without knowing anything about the database and without more
specific details, there could be many other reasons.