asked on

Storing bmp's in Access ole fields

I was copying bmp files to an ole field in an access db, and each record in the field registered each file as a 'bitmap image', if double clicked the image could be edited in MS Paint. I then installed Paint Shop Pro 5 which appeared to change all bmp files to the type 'Paint Shop Pro 5 image'. Now when bmp files are saved to an ole field the format is not recognised.

I tried deleting the file type 'Paint Shop Pro 5 image' in Windows Explorer/View Folder Options\File Types and creating a new type 'bmp' and assigning the program MS Paint to it. However when saved to the ole field
Access determines that it is a 'Package' instead of a 'Bitmap Image', and when viewed using a control in a form the image appears only as an icon.

Any ideas how to rectify?

AlexVirochovsky

You simple can save files from PSP as bmp files. For this, before save chouse in combobox "Type" "Windows bmp"(if i remember right ).

ASKER CERTIFIED SOLUTION

BrianWren

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

timsumrall

I had a similar problem geting bitmaps into the DB. Having the bitmap open in PSP while inserting worked.

ncw

ASKER

I found the problem to be too many colours. When I reduced the number of colours to 256 the Access table recognised the bmp file pasted into the ole field as a 'Paint Shop Pro 5' file and the control on the form viewed it correctly.

I think BrianWren gave the most comprehensive help so although I don't think the your answer solved the problem, I think you should take the points.

Nick