I have a table of employees and have an OLE field for each record, in which I insert a JPEG of the employee. All of the JPEGs are approx. 60 kb in size. However, each picture that I add to the database increases the database by 3-4 MB (this is after I compact the DB). Any idea what is causing this and how to keep it from happening? I have a 16 MB database that becomes about 70 MB after adding only 20 or so pictures.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
OLE Object Sizes
- Thread starter clickster
- Start date
- Thread starter
- #2
I have exactly the same problem. Please, Mr Clickster, have you found an answer?
I must add that if you delete the offending table & re-compact, you STILL have a huge file size. This suggests that this is may be a bug in Access rather than being our fault.
Pandigel
I must add that if you delete the offending table & re-compact, you STILL have a huge file size. This suggests that this is may be a bug in Access rather than being our fault.
Pandigel
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question