External Database Linking

[1stweb]

Hi,

I already have a complex database "make table" that creates a list of products I need to integrate with a website. However, I need to create a list of image names that are related to the product code. THIS I HAVE DONE. However, not all products have an image available.

What I need to do is create the image name (ProductCode.jpg) then look up in a folder called images to see if the image exists. If it does not I need to replace the filename with NoImage.jpg.

Can anyone help with this Access issue?

Thanks

[pinbrook]

If you havn't got a huge list of products, a manual method is to use the file to do an import, then use the log file generate by actinic of the lines that failed to import due missing image.

Use this info to paste in NoImage.jpg and re import

[NormanRouxel]

A quick Google for "access file exists function" got (among many others) http://allenbrowne.com/func-11.html

[1stweb]

Thanks all, especially Norman.

I searched Google and found nothing, I obviously was usign the wrong search terms. I will get onto this because the database is automatically generated everytime my client adds new stock to his system.

regards

Mark