I have linked to about 200 images files from within a table in an Access 97 Database rather than inserting the entire image into the table. I then reference that table from within a form. An image opens only when selected. The reason for this was tosave some storage space, and to keep the database to a smaller footprint. However, even though the images (xxxx.pdf) files are linked, the database has grown to at least 4-5 times the size as a result. From approx 80MB to 420MB. Am I missing something here or is Access smart enought to pre-allocate the space required to open the images? My next move is to create another database and a table to house the images then link to that database from within a Form rather than access the table within the same database. That should at least keep the size down on the main database. Any clues as to why this is happening? Compact only reduces about 10 %. Thanks.
