ExpExchHelp
asked on
BMP **object links** severely inflated size of 2013 Access database
In MS-Access 2013, I added an OLE object to a table. This fields is intended to display images in a form.
I stored my images (at this time, 29 BMP files at approximately 700 kb each) in a subfolder on my hard-drive. Via the Access form, I then added the images via the following process:
- Right-clicked on object (OLE field) that holds an image
- Selected "Insert Object..."
- Changed default option from "Create New" to "Create from File"
- Browsed to subfolder that holds the BMP images. Then selected desired image for particular record(s).
- Click "Link", and then "Ok".
Given that I chose "Link" (after selecting the file), I thought that the actual images would *not* be imported into the database (but only a link to it). Maybe I wrong though. Ultimately, after I linked those 29 images to 29 records, the size of my database increased significantly. That is, its size increased from rougly 1,000kb to 48,000kb.
As I will probably add another 200 records (also with BMP images equal to ~700kb), I could envision that the final DB will be rather sizeable.
My question: Is there another (better) way to display the images w/o increasing the DB's size dramatically?
Thank you,
EEH
I stored my images (at this time, 29 BMP files at approximately 700 kb each) in a subfolder on my hard-drive. Via the Access form, I then added the images via the following process:
- Right-clicked on object (OLE field) that holds an image
- Selected "Insert Object..."
- Changed default option from "Create New" to "Create from File"
- Browsed to subfolder that holds the BMP images. Then selected desired image for particular record(s).
- Click "Link", and then "Ok".
Given that I chose "Link" (after selecting the file), I thought that the actual images would *not* be imported into the database (but only a link to it). Maybe I wrong though. Ultimately, after I linked those 29 images to 29 records, the size of my database increased significantly. That is, its size increased from rougly 1,000kb to 48,000kb.
As I will probably add another 200 records (also with BMP images equal to ~700kb), I could envision that the final DB will be rather sizeable.
My question: Is there another (better) way to display the images w/o increasing the DB's size dramatically?
Thank you,
EEH
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Quick follow-up question...
Instead of having the database and images in the same folder, I would like to store my images in a subfolder (one below the folder where I keep my database).
Currently, the property reads: "=[CurrentProject].[Path]" .... how should I modify it in order to point to the subfolder, e.g., "Images"?
Thanks,
EEH
Instead of having the database and images in the same folder, I would like to store my images in a subfolder (one below the folder where I keep my database).
Currently, the property reads: "=[CurrentProject].[Path]"
Thanks,
EEH
ASKER
Figured it out... thank you, again.
ASKER