Link image to sharepoint and MSAccess

[Karen S]

Hi,

I'm fairly new to InfoPath and not a programmer. I have created a few
successful forms (accessible from Sharepoint form libraries).

Now I need to create a form that will update an Access database. One of the
fields needed in the database is a link to an image. I want the user to be
able to choose an image from his hard drive, upload that image to a
sharepoint library (document or image --- whatever is better) and then have
the link to that image in the form and subsequently update the appropriate
field in the access table.

Do I use a file attachment control? If so, how do I make the file attachment
control store the image on Sharepoint and then just bring the link back?

Thanks for any help you can provide,
Karen

 

[Clay Fox]

Hi Karen.

You would probably want a hyperlink not an attachment control if you are not
storing the image in Infopath but somewhere else.

There is no built in function for storing a file somewhere else and must be
done manually or through code.

You may want to store the file in the database you would need SQL and I
would recommend the Database Accelerator as I have used it to do just that.
You can find more information at http://www.qdabra.com
--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com

 

[Karen S]

Hi Clay,

Thanks for the information. I guess I will just have to put a link to a
sharepoint library where they can upload the image, and then simply enter the
image file name in the infopath form. That's probably the easiest way.