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.