i am using VB6 n MS-Access i have to save images in database which data type is use and how can i save images in database and load i can load images to VB form using the following code

Private Sub LoadPicture_Click()
    With pict
    .InitDir = "C:\Documents and Settings\Administrator\My Documents"
    .Filter = "JPEG image|*.jpg|GIF image|*.gif|BITMAP image|*.bmp|Icon image|*.ico|Cursor image|*.cur|Panerio image|*.pan"
    .ShowOpen
        If .FileName <> "" Then
        imgpic.Picture = LoadPicture(.FileName)
        End If
    End With
End Sub

bye bye

Abdul Wasie

__________________
Abdul Wasie

You need to create a field using the OLE object data type. This will save the image inside the database, but it bloats it.

Are you just making calls from VB? If so, you should open and close the back end periodically and set the database to compact on close. (Tools>Options>General tab>Check Compact On Close)


mmcdonal

thanks for the help

Abdul Wasie