store image in access table

User avatar
sal21
PlatinumLounger
Posts: 4351
Joined: 26 Apr 2010, 17:36

store image in access table

Post by sal21 »

How to store in access table the image in c:\mydir\ (are approx 2xx images)
???

note:
in mydir arte only image with .gif exstenction
from googling, i have only understand to use a fields with oleobject property :grin:

User avatar
HansV
Administrator
Posts: 78412
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: store image in access table

Post by HansV »

As far as I know, you're still working with .mdb files. It is not a good idea to store images in a database in that format. Regardless of the image format (.gif, .png, .jpg), the image will be stored in .bmp format, which will make the database huge.
Instead, store the images in a folder (for example the same folder as the database), and load them into an image control when needed.
Best wishes,
Hans

User avatar
sal21
PlatinumLounger
Posts: 4351
Joined: 26 Apr 2010, 17:36

Re: store image in access table

Post by sal21 »

HansV wrote:
12 Oct 2022, 08:06
As far as I know, you're sill working with .mdb files. It is not a good idea to store images in a database in that format. Regardless of the image format (.gif, .png, .jpg), the image will be stored in .bmp format, which will make the database huge.
Instead, store the images in a folder (for example the same folder as the database), and load them into an image control when needed.
TKS for suggestion, bro.
I choice the dir solution.