>I have stored bmp files in a general field of a database .The bmp file sizes are too large and there are many records. because of this my .fpt file size goes upto 1.9 GB. This file size is the big problem i face.packing or zapping this file takes lots of time.any other solution to store this image fields??.i have tried linking the file name instead but then it does not solve my problem.any solutions ??

What particular software you are using in scanning those images? I would advise you to use Wang Imaging because it has smaller bytes when saving it into BITMAP image as compare to other software. Also, it is reasonable to stretch the image into a smaller one before finally storing into GENERAL field.

HTH