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

    Unanswered: Insert Link/Object using script


    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.


  2. #2
    Join Date
    Apr 2006
    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