Need Help with Images in my database (DB Attachjed)

[Leopardfist]

I can not make the link thing work, and now I cannot even make it work with the images being stored in the database. My DB is very simple, and I am attaching it, along with my Images folder and a couple images. If ANYONE can figure out my problem and suggest how to fix it I would greatly appreciate it!

Thank You,
Bill

 

[RuralGuy]

Maybe Larry Linson's examples can help.

 

[Leopardfist]

Thank you ruralguy, I will take a look at it. I tried doing it like the access help says to but it wouldnt work.

Many Thanks!

 

[RuralGuy]

The Northwind sample db that comes with access also has a method of displaying pictures in the employee's form. I'll bet you discovered the size limit for zip files when you tried to upload your db. Good luck and post back if is is still a stumper.

 

[The_Doc_Man]

I'm not going to try to upload or download anything. To make images work in your database from a form, you need two things.

1. A complete path to the image file.

2. The correct image-file processing code included in the Access installation.

For instance (trivial example here), if you didn't include JPEG wizards in the Office install, Office won't easily be able to display JPEC files. It does not matter that Windows itself can open and correctly display the file. You need to set up proper references to the correct file handler for Access.

In a form, if you have a table with a field that holds the image specs, then in the form's OnCurrent event you can load a path to a form's image control. Play with the settings.

If you are giving the correct path and loaded the proper wizard, this should work. Unless you did something silly like change the name of the file. Because, you see, Windows actually BELIEVES what you tell it about what type of file it is based on... the file type.

So if you put a .WMF file type on a file, it had better be a Windows MetaFile image. If you put a .JPG file type on a file, it had better be a JPEG file. Etc. etc. etc. Also, beware of files that include internal checksums or other methods of detecting corruption. If the file is corrupted, it might not show correctly. Another thought is that you didn't say what version of Access or Windows you are running. If it is WinXP with service pack 2 installed, your machine's security setting has been ramped up. Because of that, some types of image don't want to play any more.

If you were trying to link images via OLE in a table vs. opening a form, you have opened up another can of worms having to do with OLE activation. This is yet another hot-button for Windows security.

 

[Leopardfist]

OH MAN! That is EXACTLY what I did. Two things actually.

1. I found the file size limit on uploads, and even with my basic empty db with just one form it was like 10 times the limit.

2. The computer I was working on at the time only had the basic access installed, I did not do the full install or the Developer install.

I will use the link above though to figure out the linking to images aspect. I tried doing what is done in the sample database, to do the images AND the file dialog, and it wouldnt work. I suspect it is because I was using a different version of office or access.

THANKS for the great help guys and gals!

 

[Oldsoftboss]

Try the "ImageSample2000" post here

http://www.access-programmers.co.uk/forums/showthread.php?t=113758

Dave