Thank you for the reply.
After my first post, more research tought me of the OLE Object you speak of. I used it, selected "Create From File" and selected the .jpg I needed for testing. When I pull up the report, I can't see the photo however. Instead, I see a small square with only the name of the file. I'm going to need those photos to print out on the reports.
My next fix was to choose, "New Microsoft Word Document" instead of "Create From File". When Word opened, I insterted the picture I needed into the blank document. When I close the document, it is stored in the table. In the report, the photo displays. That's the good news. The bad news is that most of the photos they take are at a high resolution and require 4 to 7 MB of file space. When I try try saving a word file with one of these large photos, Access screams that there isnt' enough system memory to perform the operation. It asked me to close unused programs and try the operation again. Access is the only program I have open. System resources looked fine in the task manager so I'm not sure why this is an issue. I'm now wondering if it will not hold these large files. I did not use the "link" feature. Instead, I am trying to embed the photo into the database. I am having no problems with .bmp files. Only the jpegs aren't showing up on the report.
So now I'm out with two questions. First, will Access allow me to store HUNDREDS of photos with such large file sizes? Second, is there another way to get a .jpg into the table so it prints on the report without having to first put the picture in a Word document?
This is version 2002 from Office XP Pro (all service packs installed).
Any and all information will be greatly appreciated.
I'm going to check the links you posted now.
Thanks for your help thus far.
Edited by magusbuckley, 30 December 2006 - 03:27 PM.