Images linked with Databases?

  • Hey there... erm i have a Music Database (well im just creating) and i have a whole bunch of artist pictures, is it possible to link these images to the database so when on the form the picture displays? ive seen it in use but i dont know how todo it? How do i put the picture into the design layout of the form, what field type etc?



  • Re: Images linked with Databases?

    I can't explain it any better than the Help Files ;)

  • Re: Images linked with Databases?

    I've found the fastes way to get binary data in and out of Access is with the Adodb.Stream Object - assuming I have opened an Access Table as a Recordset and it contains an OLE field "image" - and I want to pack a JPEG file... something like

    S = CreateObject("ADODB.Stream")
    S.Type = 1 ;binary stream
    RS.Fields("image").Value = S.Read(-1)



  • Re: Images linked with Databases?

    Cool, I am glad I did a search before asking. This is exactly what I was looking for. But let me extend the question just a bit.

    How would I set up a default picture(Like a picture that says unavailable)?

    [SIZE=2]I should change my name to STUMBED![/SIZE]

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!