Using MS Access/Upload images
I am using access 2010 as FE. I have the BE tables on an SQL server. My question: how can I upload images? I would love to have something similar to attach files as in access which is unfortunately not available in the SQL BE tables.
First, I'm assuming that you want to associate images with a record in your database. That's not the same as Upload. To Upload means to send a file from your PC to a remote computer.
You can store images in a SQL Server table, Unfortunately, I'm not a SQL Server expert so I can't tell you much more than that.
But there is another way to work with images using Access. And that is to store the location of the image as a text field in a table. You can then display the image on an Access form using the following method.
On the form you add an unbound Image control (this is the last control in the Controls list). You then use the On Current event of your form to run code like:
If IsNull(Me.txtImagepath) then
Me.imgControl.Picture = default pic
Me.imgControl.Picture = Me.txtImagepath
You also want that same snippet in the After Update event of txtImagePath.
Note: txtImagepath is a control on your form bound to the field holding the path to the image. imgControl is the name of the Unbound Image Control and default pic is the path to a default image to show is none is associated with the record.
Hope this helps,
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA