Bitmap in MS Access database

I need add a bitmap into a MS Access database (ver. 7.0) but the vbBinary format is not valid.
How do I add a picture into a record???

Had similar problem.

Gave up!

In the end elected to store a string of path and file name of image in table. Then used the LoadPicture("path\filename") method to set image.

I have done this storing picture into MS-Access, I hope this would be helpful to you.

creat a OLE1 control into the form.

and create a Command button.

then include

Private Sub Command1_Click()
OLE1.InsertObjDlg
End Sub

Include Datacontrol to the form.

Assume the name Data1

and the Access database has a got field for BITMAP image named "PHOTO" which is of datatype OLE Object

then in the properties of Datacontrol

OLE1.Datasoure = Data1
OLE1.Datafield = PHOTO

You have to create field not with Binary but with OLE Object data type.

Best regards,


------------------

Serge

[email protected]
[email protected]
If you have any questions about AOL programming, e-mail me