Error Message: The field is too small to accept ...

C

CWDev

I have a front/back-end application that is suddenly producing the error "The
field is too small to accept the amount of data ... ".

Oddly, the application has been running fine for months. Friday it ran ok
but Monday the "field is too small" problem cropped up. The only change in
the interim is that I ran Compact and Repair on the back-end database.

The "too small" problem now exists on all workstations running the front-end.

Does anyone know the answer? MSDN says nothing about this.
 
J

John Vinson

I have a front/back-end application that is suddenly producing the error "The
field is too small to accept the amount of data ... ".

Oddly, the application has been running fine for months. Friday it ran ok
but Monday the "field is too small" problem cropped up. The only change in
the interim is that I ran Compact and Repair on the back-end database.

The "too small" problem now exists on all workstations running the front-end.

Does anyone know the answer? MSDN says nothing about this.
Click to expand...

Something's corrupt somewhere! I'd suggest starting by junking this
frontend and replacing it with a backup copy - or at the least, using
the Linked Table Manager to refresh all the table links, and then
Compacting the frontend.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
C

CWDev

Compact and Repair did the trick. Very strange though, 2 workstations came
down with the problem at the same time. Oh well ... another question that
will forever go unanswered.

Thanks for your help!
 
Top