How to insert image field into ms access table

Applications Forms
#1

All the samples work over mysql tables, BUT I need to insert an image field into a MSACCESS table, when save or update DATA I receive an error message “MSAccess: query is very complex”

please help me

#2

I have been working over it. If you choose the image field to be an OLE Object in access, then you can save the link(of the Image) in Scriptcase as the field Image(Filename). This can allow you to handle images in access…

#3

Hi coolsumitan,

Thanks by your help, I made the changes and my app is working,
I change from image (in database) to link (image on subfolder) I put the subfolder as “fotos” BUT Where is the image subfolder ??? where scriptcase create these subfolder ?

I find in my laptop and not found these subfolder

aquiles

#4

[SOLVED] I found and understand where SC save the images and photos,

NOW, the problem is : where I can CHANGE the file name,
my porposal is to create a relation between the product_code (by example) and the image name, prod_code IMC-005 and photo name IMC-005