We have an ACCESS 2000 database with a TABLE, with an OLE Object field that stores photographs. These photographs are supposed to be taken at a low resolution and cropped so that the file size doesn't get huge.
Problem is people are occassionally lazy and don't CROP and/or take the pic at the right RESOLUTION.
So what should be an 8 or 9 meg data file jumps up to 200 meg because people insert a few dozen 5 megapixel jpg's.
Is there a command or some code in ACCESS that will return a value representing the picture file size for each record? And is there something that will return the picture file type (bmp, jpg, etc...)
I was thinking I would create two new fields to hold this information. That way I could look through the database & see which files are so big.