External images are saved in MsSysResources table - How to avoid it?

I am developing an employee database which displays the employee's Picture when his/her record is selected.
The Picture is displayed using the following procedure:

Private Sub Form_Current()
  On Error GoTo ErrorPicture
    imgPicture.Picture = CurrentProject.Path & "\fotos\" & emp_Picture
    On Error GoTo 0
    Exit Sub
    
ErrorPicture:
    On Error Resume Next
    imgPicture.Picture = CurrentProject.Path & "\fotos\_Person.png"
End Sub

Open in new window


The Problem is that the image is added to the hidden MsSysResources table.
With almost 300 Pictures, the database has grown from 5 MB to 200 MB in size.
Is there a way to not store the images in this table?

Thanks for your feedback

Massimo
Massimo ScolaInternshipAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Daniel PineaultPresident / Owner CARDA Consultants Inc.Commented:
See Adding Attachments to an Access Database for everything you need to know on the subject.
Anders Ebro (Microsoft MVP)Microsoft DeveloperCommented:
This occurs when the "Picture Type" property of the image control is set to "Shared"
Change the picture type to Embedded, and the images should no longer be stored.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Gustav BrockCIOCommented:
You can use the simple and proven method as described in my article:

Show pictures directly from URLs in Access forms and reports

A full demo is included.
SolarWinds® Network Configuration Manager (NCM)

SolarWinds® Network Configuration Manager brings structure and peace of mind to configuration management. Bulk config deployment, automatic backups, change detection, vulnerability assessments, and config change templates reduce the time needed for repetitive tasks.

Daniel PineaultPresident / Owner CARDA Consultants Inc.Commented:
Just to follow-up regarding switching the Picture Type to Embedded, although not stored in the MsSysResources  table, it is still being embedded within the database, so you still get bloating and for systems with lots of such images it remains a problem (you can fast approach the 2GB file size limit).  Storing the paths/filenames as text remains the proper solution for such cases.  Personally, I only embedded things like button images and the likes (GUI components that I know are 100% static), but all content relating to records are simply stored as plain text.
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Yes, you would want to link images so they don't get stored anywhere in the DB.

Jim.
Massimo ScolaInternshipAuthor Commented:
That worked - thanks a lot!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.