Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Posts
    97

    Unanswered: Insert Link/Object using script

    Okay,

    I've written a VBA function that grabs the filename and path information for a file from a directory. This information is then inserted into a table using "INSERT INTO...".

    That works fine. However (and this is a big however), I'd like to use this with some images using an OLE field. I realize the size constraints and such but felt I could get around this using the link. However, when I use the above method all I get is a "Long Binary Data". If I do this same process manually, it views the linke as a valid .bmp or .jpg.

    I realize ithe function is just taking the string value for the link and not seeing this as a valid link but I'm not sure how to fix this. All the info I've seen is only for reports and forms.

    Any ideas would be welcome.

    Thanks
    Chris

  2. #2
    Join Date
    Apr 2006
    Posts
    157
    let me get this straight, you already have the file's path and you want to somehow store the file as an embeded in the database?
    Only quitters quit!

Posting Permissions

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