Inserting Images From Microsoft Access Front End Form To Mysql Backend on Webserver

[darren13]

Hi Guys,

Been trying to do this for a (long) while now. I've set up a Microsoft Access front end, which links through to the Mysql backend on our webserver.

I use the database for producing estimates and invoices / quotations, and need to upload digital images taken with my camera onsite to reference when pricing for jobs.

I've tried adding a 'blob' field to the Mysql backend, and then added a field on my form in Access (to display the image).

It doesn't display the image I've uploaded via Mysql, and I can't figure out how to add a button to the form to select the images.

Basically I'd like to press a button on the form in Microsoft Access, choose the image(s) and then have the images inserted in to the mysql table and displayed in the form.

Any help greatly appreciated....

Thanks,
Darren.

[Dubbya]

These sites might be of use to you:

Alzowze - Using Blobs with Microsoft Access

http://www.microsoft.com/technet/pro....mspx?mfr=true

sql blob Resources | TechRepublic

[carol]

I've never actually used Access as a stand-alone application, so maybe what I'm about to suggest isn't possible. But instead of storing the actual image in the database, can you store the path to the image file? So that when you display the form, it picks up the image by its file name/address?

[niggles]

Hi,

I've always gone down the path of just storing a reference to the file instead of the actual file in the database - this way your database doesn't grow to be a crazy size.

Cheers,
Niggles

[angeldemon]

its considered best practice to put images on the filesystem instead of the database.