I am trying to organize an extensive number of pictures (1000+ JPG files) into an MS Access 2000 application. What I've done so far is to import the JPGs into the database as OLE Objects. The problem is the resulting size of the database. The JPGs themselves are relatively small and total less than 100mbs but the database is close to 600mbs. Ultimately, I intend to create a run time version of this database for distribution to hundreds of users so I need to be able to fit the entire database onto one CD. I need the various images to show up on various forms and reports generated by the application. I've considered using links to the files instead of embedding the files but I am concerned that this could be problematic when I distribute the compiled application on CDs.

Any thoughts or insights into this would be most appreciated.