How to import image into access?

Asked By benjamin 460 points N/A Posted on - 12/13/2012

 

Hi,

How to import image into access? Is there a way that a Microsoft Access database system will handle big images file? Would it possibly handle jpg, gif and png file formats? If there is some way that the ms access database can do so please let me know. Thank you.

Regards,

Benjamin.

• Status: Open
• Question Views: 1044
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Access

Best Answer by Dyer Pearlman

Go To Solution

Answered By Dexter Alberto 0 points N/A #92399

How to import image into access?

Hi,

Its not usually recommended to store images in an Access Database because it bloats the size of the MDB. This makes the file more prone to corruption. A solution can be to store the files outside the mdb like in a table and store only a string path to the external  file location in the Access Database.  The string path can be used to display the images on forms or reports at runtime.

Thank you.

About Dexter Alberto

Questions
3

Answers
99

Best Answers
34

• Vote Up 0 Vote Down

• Posted on - 12/28/2012
• Question Category: MS Access

Best Answer

Best Answer

Answered By Dyer Pearlman 0 points N/A #92401

How to import image into access?

Hello

I would suggest you use “dbpix” to add pictures to MS access database easily and fast. The benefits of using this software are:

a) It is very easy and efficient. It has a seamless integration with MS Access DB

b) Prevents image GotChas like complex coding, performance problems etc.

To download dbpix follow click this link http://www.ammara.com/dbpix/access.html

Some of the technical capabilities are:

1. Has an integrated EXIF viewer
2. Also supports visual basic, Explorer in addition to Access
3. Has the ability to optimize on quality and storage space

About Dyer Pearlman

Questions
3

Answers
102

Best Answers
62

• Vote Up 0 Vote Down

• Posted on - 05/21/2013
• Question Category: MS Access