Image In Access Window

[PC User]

I came across a module that I'm considering on using; however, I can't get it to work. It's called Image In Access Window and I got it from The Access Web website. I have some questions.
1) Has anyone been able to get this to work?
2) Has anyone tried to make this work with the image on the form; instead of using a path to an image file on the computer's harddrive?
3) Does anyone have a working sample on this?

Thanks,
PC

 

[KeithG]

Why can't you get it to work? What happens when you try?

 

[PC User]

Ok. I was able to get it to work; however, it still is dependant on an external image file. Is there a way to get it to utilize the image that I've placed on the form?

Thanks,
PC

 

[Simon_MT]

Using external files is more efficient method to handle images.

Otherwise all the data seeks have to hurdle over these images everytime to get the information you want. This is on top of bloating your database with OLE objects, even blobs in the images' native format would still consume space. My image directories of low resolution stands at 850MB representing 16,000 images.

Simon

 

[PC User]

If I understand you correctly, everytime I enter data or print a report etc. that the database has to process the image module and refresh the image?

Thanks,
PC

 

[Simon_MT]

Yes, Access would need to dynamically process each image. It is a database afterall.

Your method is much better that Access 97, which only has OLE support. I had to purchased an ActiveX solution. The later versions of Access may have proper image support but as I still happy using dbpix, I haven't investigated.

Simon

 

[PC User]

I recently upgraded to Access 2007, but I'm not familiar with all the advanced features.

Thanks,
PC