Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Mar 2003
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Update Query and OLE file names (2000)

    I would like to write an update query to insert the file names of jpegs. One field in my table includes the name of the file without the file path or extension, will call this nopicture. Example: 0101. The file name and path is, for example, j:database0101.jpg. I created another OLE field in this table, and I tried to combine the path names with the field nopicture in the query, but it's just giving me "Long binary data". Is there any way that I can do this in an update query?

    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Update Query and OLE file names (2000)

    In general, you shouldn't store images in an Access table, just the file path and name. Images cause tremendous file size bloat. So you don't need an OLE field in the table or query, just a text field (or hyperlink field, if you prefer). You can display the images on a form or report using the Image control. See the attachment to <post#=296892>post 296892</post#> for an example of how to handle images.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •