User inputs picture, saving picture, linking to picture

[grable]

I would like to know how I could create a picture field as part of my database that will enable the user to paste/put/dragdrop a picture into the field.

The field will be linked to a table column in my database so that when the user pastes a picture on the form, access will store the picture into the table.

I would then like to write some vb code that will interact with the database. It should take those pictures stored in the table and then copy them into newly created files on the hard drive. Then it will be able to replace the picture files in the database with simply the links (so that the size of the access file is not huge).

After the links are created, when browsing through the records, one will be able to see the linked pictures on the form.

Thanks.

 

[braindead2]

If it was me I would simply store the path to the file as a hyperlink

 

[THoey]

I agree 1000% with Braindead2. When you store images in an Access table, it actually takes more room that the file size. Your MDB will grow dramatically.

(BTW Braindead2, when you going to become a full time member? I have seen you post several great answers to threads.) Terry M. Hoey
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.