How to import image into access?

Asked By 460 points N/A Posted on -
qa-featured

 

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.

SHARE
Best Answer by Dyer Pearlman
Answered By 0 points N/A #92399

How to import image into access?

qa-featured

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.

Best Answer
Best Answer
Answered By 0 points N/A #92401

How to import image into access?

qa-featured

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

Login/Register to Answer

Related Questions