access the field is too small to accept the amount of data you attempted

[jcaptchaos2]

I did a lot of searching on this error and none of the suggestions seem to help, what I did find is the query that is run has been working fine until today so I thought I would go to the tables and delete the lines that were created since yesterday, well that worked so I spent the day looking at eack record trying to figure out whick record was causing the query to fail. I found that it wasn't a certain record it was the number of records in one of the tables, it didn't matter which records I deleted but if I delete around 75 of them the query ran fine. Any ideas?

 

[boblarson]

Do you have a field set as INTEGER? It could be that you have more than 32,767 records which could cause the problem. You would change it to LONG INTEGER.

 

[jcaptchaos2]

Bob,

Thanks for your reply, the three fields in the table that contain numbers are all set to long integer.

 

[xenou]

Maybe your database has reached its maximum file size (?)

 

[jcaptchaos2]

The 2 tables that the query is using have about 7700 records in them each, what is the max?

 

[xenou]

The database as a whole has a max file size. I think it's either 2Gb or 4Gb.

 

[boblarson]

2 gb max file size.

 

[jcaptchaos2]

The database is far from that, only 58,000KB

 

[boblarson]

Try narrowing the focus to the actual field that is causing the problem.

 

[xenou]

I would be very surprised if the error was not because you are trying to add data to a field that is too small to accept it ... it's hard say more without knowing the field types of your tables and what the data is that you are working with, and what the query does.

ξ