{"id":65196,"date":"2025-04-23T11:08:39","date_gmt":"2025-04-23T11:08:39","guid":{"rendered":"http:\/\/www.accessrepairnrecovery.com\/blog\/?p=65196"},"modified":"2025-04-27T09:50:25","modified_gmt":"2025-04-27T09:50:25","slug":"how-to-insert-image-in-ms-access-database","status":"publish","type":"post","link":"https:\/\/www.accessrepairnrecovery.com\/blog\/how-to-insert-image-in-ms-access-database","title":{"rendered":"How to Insert Image in Access Database? \u2013 (2025 Guide)"},"content":{"rendered":"<div class=\"8e1a49907eb0ebe2b39ac6355e555698\" data-index=\"1\" style=\"float: none; margin:0px 0 0px 0; text-align:center;\">\n<style>\r\n.leaderboard { width: 320px; height: 100px; }\r\n@media(min-width: 500px) { .leaderboard { width: 468px; height: 60px; } }\r\n@media(min-width: 800px) { .leaderboard { width: 728px; height: 90px; } }\r\n<\/style>\r\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-8329139124199643\" crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle leaderboard\"\r\n     style=\"display:inline-block\"\r\n\t data-full-width-responsive=\"true\"\r\n     data-ad-client=\"ca-pub-8329139124199643\"\r\n     data-ad-slot=\"1972481166\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<p style=\"text-align: justify;\">As we all know, Microsoft Access allows users to store images directly in their database. This feature is ideal for applications requiring product photos, employee IDs, or client files. You can store pictures in a table using specific data types like OLE Object or Attachment. It also makes your data visually appealing and easier to understand. Well, in this blog, I will show you <strong>how to insert image in Access database <\/strong>quickly and efficiently.<\/p>\n<p><!--more--><\/p>\n<div style='margin: 10px 0; clear: both;'><div style='clear: both; border-top: 1px solid #eeeeee; border-bottom: 1px solid #eeeeee; margin: 30px auto; padding: 15px 15px 15px 20px; display: flex; align-items: center; justify-content: space-between;'><div style='margin-bottom: 0; line-height: 1.6; flex-shrink: 1;'><span style='color:#aaa; font-size: 13px;'>Rated <i>Excellent<\/i> on <a rel='nofollow' target='_blank' href='https:\/\/www.trustpilot.com\/review\/www.stellarinfo.com'><span style='color: #aaa;'>Trustpilot<\/span><\/a><\/span><br><strong>Free MS Access Database Repair Tool<\/strong><br>Repair corrupt MDB and ACCDB database files and recover deleted database tables, queries, indexes and records easily. Try Now!<br><div style='margin-top: 5px;'><a style='background: #b10923; border-radius: 25px; color: #ffffff; cursor: pointer; display: inline-block; font-size: 16px; font-weight: 500; padding: 0 16px; height: 40px; line-height: 40px; vertical-align: middle; white-space: nowrap; text-decoration: none; border: none;' href='https:\/\/www.accessrepairnrecovery.com\/blog\/get-access-file-repair-tool' target='_blank'><span style='color: #ffffff;'><i class='fas fa-arrow-alt-circle-down'><\/i><\/span> Download<\/a><br><span style='font-style: italic; display: block; font-size: 10px; margin-top: 10px;'>By clicking the button above and installing Stellar Repair for Access (14.8 MB), I acknowledge that I have read and agree to the <a href='https:\/\/www.accessrepairnrecovery.com\/eula.php' target='_blank'>End User License Agreement<\/a> and <a href='https:\/\/www.accessrepairnrecovery.com\/privacy-policy.php' target='_blank'>Privacy Policy<\/a> of this site.<\/span><\/div><\/div><\/div><\/div>\n<h2 style=\"text-align: left;\"><strong>Can Microsoft Access Store Images?<\/strong><\/h2>\n<p style=\"text-align: justify;\">Yes, you can store images in your Access database. Well, this task is possible by using attachments that store multiple types of files in a single field.<\/p>\n<p style=\"text-align: justify;\">Suppose you have made a <strong>job contact database<\/strong>. By using the attachments, you can attach one or more resumes for each contact\u2019s record, and can also insert a photo of the contact.<\/p>\n<p style=\"text-align: justify;\">Previous versions of the MS Access database make use of a technology known as Object Linking and Embedding (OLE) for storing documents and images. By default, for each image and document, OLE generates a bitmap.<\/p>\n<p style=\"text-align: justify;\">These bitmap files are quite large in size. 10 times greater than the original file. When a user views their image and document from their database, OLE displays only the bitmap, not the original one. Apart from that, OLE needs programs known as OLE servers to work.<\/p>\n<p style=\"text-align: justify;\">In contrast, MS Access attachments store the attached file in its native format. So, you don\u2019t need to install any additional software to see images in your database.<\/p>\n<h2 style=\"text-align: left;\"><strong>What Are Techniques To Handle<\/strong><strong> Image In Access Database?<\/strong><\/h2>\n<p style=\"text-align: justify;\">This is one of the most commonly asked questions regarding the insertion of images in the Access database. Well, there are many ways or techniques to add images in the Access database. so, let\u2019s discuss them one by one.<\/p>\n<ol style=\"text-align: justify;\">\n<li style=\"text-align: left;\">In the OLE field store the image you want to insert. After then for the image display just make use of the bound object frame.<\/li>\n<li style=\"text-align: left;\">Store image path in the text field and to show the image make use of image control.<\/li>\n<li style=\"text-align: left;\">Another way is to store the picture in <strong>Binary Large object bitmap (BLOB)<\/strong> within an OLE field. Whenever you need just extract the picture you want and make use of image control for an easy view of the image.<\/li>\n<\/ol>\n<p style=\"text-align: justify;\">All the techniques mentioned here to <strong>insert picture in Access database<\/strong> has some advantages &amp; disadvantages too. So, let\u2019s discuss them in brief.<\/p>\n<blockquote>\n<p style=\"text-align: left;\"><strong>Also Read: <\/strong><strong><a href=\"https:\/\/www.accessrepairnrecovery.com\/blog\/integrate-ms-access-and-outlook\">How To Import Outlook Email Into Access Database?<\/a><\/strong><\/p>\n<\/blockquote>\n<h2 style=\"text-align: left;\"><strong>How To Insert Image In Access Database Through Attachments?<\/strong><\/h2>\n<p style=\"text-align: justify;\">For using attachments in your Access database, you need to first add an attachment field in at least a single table of your database. MS Access provides two ways to add such attachment fields within your database table. You can either add attachment fields in the Datasheet view or in the Design view. \u00a0Here we are trying this with the Datasheet view.<\/p>\n<h4 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>Add an attachment field in Datasheet view<\/strong><\/span><\/h4>\n<ol style=\"text-align: justify;\">\n<li>Open your Access database table in Datasheet view, and tap to the first available blank column. It\u2019s not that tough to fetch a blank column, just look for the words \u201c<strong>Add New Field\u201d <\/strong>on the column header.<\/li>\n<li>Now on the <strong>Datasheet <\/strong>tab, within the\u00a0<strong>Data Type &amp; Formatting<\/strong> group, tap the down arrow present next to <strong>Data Type<\/strong>. After then tap to the <strong>Attachment <\/strong><\/li>\n<\/ol>\n<p style=\"text-align: justify;\">For the attachment field Access will set the data type. Also, place one icon in the field\u2019s header row. The shown figure is of the new Attachment field. You can see an icon of a paper clip in the header row of the field. You are not allowed to put text in the attachment field\u2019s header row.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-65205\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/76189461-1bd0-48c0-92c0-872f0b7edeaf.gif\" alt=\"Add an attachment field in Datasheet view\" width=\"184\" height=\"78\" \/><\/p>\n<ol style=\"text-align: justify;\" start=\"3\">\n<li>It\u2019s time to save all the changes you have done.<\/li>\n<\/ol>\n<p style=\"text-align: justify;\"><strong>Note:<\/strong><\/p>\n<p style=\"text-align: justify;\">You are not allowed to convert any new field into another data type. but if any error takes place then you can delete the field.<\/p>\n<h4 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>Add An Attachment To A Table<\/strong><\/span><\/h4>\n<ol style=\"text-align: justify;\">\n<li>In the table having your attachment field opened in datasheet view. Make a double tap on the attachment field.<\/li>\n<\/ol>\n<p style=\"text-align: justify;\">This will open the\u00a0<strong>Attachments<\/strong> dialog box as shown in the below figure:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-65203\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/8fc84898-70b3-42c0-bc8c-d0c0ce521ac5.gif\" alt=\"Add An Attachment To A Table\" width=\"328\" height=\"231\" \/><\/p>\n<ol style=\"text-align: justify;\" start=\"2\">\n<li>Now click on the <strong>Add <\/strong>button, this will open the <strong>Choose File <\/strong>dialog box.<\/li>\n<li>Make use of the\u00a0<strong>Look in <\/strong>list to browse for the file\/files which you need to insert in your record. After making a selection for the file tap the<strong> Open option<\/strong>.<\/li>\n<li>Now in the\u00a0<strong>Attachments <\/strong>dialog box, tap the <strong>OK <\/strong>option for adding the files with your table.<\/li>\n<\/ol>\n<p style=\"text-align: justify;\">Access adds files with the field and increases the number of attachments according to that. The below-shown figure shows the field with two attached images:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-65204\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/468d4304-cfeb-44c5-baa8-492f94210993.gif\" alt=\"Add An Attachment To A Table 1\" width=\"161\" height=\"134\" \/><\/p>\n<ol style=\"text-align: justify;\" start=\"5\">\n<li>Repeat the same step whenever you need to add files to the current field or any other fields of the Access table.<\/li>\n<\/ol>\n<h2 style=\"text-align: left;\"><strong>How To Insert Image In Access <\/strong><strong>Using OLE Object Fields?<\/strong><\/h2>\n<p style=\"text-align: justify;\"><strong>OLE <\/strong>object is one such data type that helps you to easily save files generated by some other programs like Excel spreadsheets, Word documents, or graphics. This section gives you an idea of how to work with the OLE object fields.<\/p>\n<h3 style=\"text-align: left;\"><strong>Steps To Insert Image In Access <\/strong><strong>Using OLE Object Fields<\/strong><\/h3>\n<p style=\"text-align: justify;\">Here we are using a table name <strong>tblEmployees <\/strong>and a form name <strong>frmEmployees,<\/strong>\u00a0which is previously made.<\/p>\n<ol style=\"text-align: justify;\">\n<li>Choose the table tblEmployees after that tap to<strong> the Design<\/strong> button.<\/li>\n<\/ol>\n<p style=\"text-align: justify;\">Now insert the OLE field into this tblEmployees table.<\/p>\n<ol style=\"text-align: justify;\" start=\"2\">\n<li>Tap to the firstly found blank Field Name row after then type text \u201cPhoto\u201d. Hit on the arrow list containing the\u00a0 <strong>Data Type<\/strong>. Then from the list of data types, choose the <strong>OLE Object<\/strong>.<\/li>\n<\/ol>\n<p style=\"text-align: justify;\">Great job, your OLE Object field is created now..!<\/p>\n<ol style=\"text-align: justify;\" start=\"3\">\n<li>Now save all the changes. To view the table in the datasheet view hit on the <strong>View button<\/strong> from the toolbar.<\/li>\n<\/ol>\n<p style=\"text-align: justify;\">Now we are adding some OLE objects into the record of Maria Wyatt.<\/p>\n<ol style=\"text-align: justify;\" start=\"4\">\n<li>Tap to any of the fields for selecting <strong>Maria Wyatt<\/strong> after then scroll on the right section. Tap to the Photo field to get into the Maria Wyatt record, and choose the Insert Object option from the menu.<\/li>\n<\/ol>\n<p style=\"text-align: justify;\">This will open the dialog box of &#8220;Insert Object&#8221; dialog box on your screen.<\/p>\n<p style=\"text-align: justify;\">For creating and inserting any new object, select the option &#8220;<strong>Create New&#8221;<\/strong>. Other than this, just a click on\u00a0 &#8220;<strong>Create from File&#8221;<\/strong> option for inserting an already existing file.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-65206\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/access-1.png\" alt=\"How To Insert Image In Access Using OLE Object Fields\" width=\"500\" height=\"222\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/access-1.png 500w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/access-1-300x133.png 300w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><\/p>\n<ol style=\"text-align: justify;\" start=\"5\">\n<li>Here we have chosen the option<strong> &#8220;Create from File&#8221;<\/strong>. So, after choosing it you need to assign name and the destination of the file that you require to insert.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-65210\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/access-2.png\" alt=\"How To Insert Image In Access Using OLE Object Fields 2\" width=\"500\" height=\"214\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/access-2.png 500w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/access-2-300x128.png 300w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><\/p>\n<ol style=\"text-align: justify;\" start=\"6\">\n<li style=\"text-align: left;\">Now tap the Browse option. After pressing on this option, make a selection for the image file that you need to insert into your document.<\/li>\n<\/ol>\n<ol style=\"text-align: justify;\" start=\"7\">\n<li>Once you get it, make a double-click on it eg, <strong>Maria.bmp<\/strong> file.<\/li>\n<\/ol>\n<p style=\"text-align: justify;\">On the side of the \u201cbrowse\u201d button, you can see a \u201cLink\u201d checkbox. \u00a0This checkbox is for determining whether this OLE object, merely linked with the Access database or actually embedded into the database.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-65209\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/access-4.png\" alt=\"How To Insert Image In Access Using OLE Object Fields 2\" width=\"148\" height=\"42\" \/><\/p>\n<p style=\"text-align: justify;\">Here we leave this link box unchecked, as we desire to embed graphics within the database.<\/p>\n<ol style=\"text-align: justify;\" start=\"8\">\n<li>After completing the procedure, tap on the OK option. This will close the open dialog box and access will embed the Maria.bmp picture within the Photo field.<\/li>\n<\/ol>\n<p style=\"text-align: justify;\">But the problem that occurs with these OLE object fields, is that it won\u2019t show the native OLE objects. That\u2019s the reason why you need to make use of the form with the OLE object fields to work smoothly.<\/p>\n<ol style=\"text-align: justify;\" start=\"9\">\n<li>Now close the table name <strong>tblEmployees<\/strong>. Tap to <strong>Forms<\/strong> icon present in <strong>Objects bar<\/strong>. Hit <strong>frmEmployees<\/strong> form, After then tap to <strong>Design<\/strong> option.<\/li>\n<\/ol>\n<p style=\"text-align: justify;\">Now you need to add a new photo field into your <strong>frmEmployees<\/strong> form.<\/p>\n<ol style=\"text-align: justify;\" start=\"10\">\n<li>After then tap to button <strong>Field List<\/strong> present on the toolbar. You can select &amp; drag down the Photo field at any place on your Access database form.<\/li>\n<\/ol>\n<p style=\"text-align: justify;\">Other than this, you can display the field list to choose view&gt;&gt;Field List present on the menu.<\/p>\n<p style=\"text-align: justify;\">You don\u2019t have to worry about the position for placing the <strong>OLE object <\/strong><strong>Photo field<\/strong>. As, by using any form of control, users can easily resize and move OLE object fields.<\/p>\n<p style=\"text-align: justify;\">Let\u2019s check it out how this Photo field appears in the Form view.<\/p>\n<ol style=\"text-align: justify;\" start=\"11\">\n<li>Hit <strong>View<\/strong> option on toolbar for making the switch to the Form view. Tap to <strong>Next Record Navigation<\/strong> option until and unless you get Maria&#8217;s record.<\/li>\n<\/ol>\n<p style=\"text-align: justify;\">Yeh, great work here is your inserted image!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-65208\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/access-3.png\" alt=\"How To Insert Image In Access Using OLE Object Fields 4\" width=\"500\" height=\"370\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/access-3.png 500w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/access-3-300x222.png 300w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><\/p>\n<h2 style=\"text-align: left;\"><strong>How To Insert Image In Access By VBA code?<\/strong><\/h2>\n<p style=\"text-align: justify;\">In your Access database make a Memo field for storing the Image. use the following code to <strong>insert image into the Access database using VBA code:<\/strong><\/p>\n<blockquote>\n<p style=\"text-align: justify;\"><em>Dim FN As Long<\/em><br \/>\n<em>Dim FB<\/em><\/p>\n<p style=\"text-align: justify;\"><em>FN = FreeFile<\/em><br \/>\n<em>Open &#8220;C:\\Pict1.bmp&#8221; For Binary Access Read As FN<\/em><br \/>\n<em>FileBinary = Space(LOF(FN))<\/em><br \/>\n<em>Get #FN, , FB<\/em><br \/>\n<em>Close #FN<\/em><\/p>\n<p style=\"text-align: justify;\"><em>&#8216;Open RecordSet RS<\/em><br \/>\n<em>rs.AddNew<\/em><br \/>\n<em>rs(&#8220;ImgName&#8221;) = &#8220;Picture1&#8221;<\/em><br \/>\n<em>rs(&#8220;ImgMem&#8221;) = FB<\/em><br \/>\n<em>rs.Update<\/em><\/p>\n<\/blockquote>\n<p style=\"text-align: justify;\"><strong>To retrieving image file From Access:<\/strong><\/p>\n<blockquote>\n<p style=\"text-align: justify;\"><em>Dim MPict<\/em><br \/>\n<em>Dim FN As Long<\/em><br \/>\n<em>&#8216;Place an Image Control(Image1) on the Form<\/em><br \/>\n<em>&#8216;Open Recordset RS here<\/em><\/p>\n<p style=\"text-align: justify;\"><em>MPict = RS(&#8220;ImgMem&#8221;)<\/em><br \/>\n<em>If Dir(&#8220;C:\\Temp.bmp&#8221;) &lt;&gt; &#8220;&#8221; Then<\/em><br \/>\n<em>Kill &#8220;C:\\Temp.bmp&#8221;<\/em><br \/>\n<em>End If<\/em><\/p>\n<p style=\"text-align: justify;\"><em>FN = FreeFile<\/em><br \/>\n<em>Open &#8220;C:\\Temp.bmp&#8221; For Binary Access Write As #FN<\/em><br \/>\n<em>Put #FN, , MPict<\/em><br \/>\n<em>Close #FN<\/em><\/p>\n<p style=\"text-align: justify;\"><em>Image1.Picture = LoadPicture(&#8220;C:\\Temp.bmp&#8221;)<\/em><\/p>\n<\/blockquote>\n<h2 style=\"text-align: left;\"><strong>Insert Picture into MS Access\/SQL table using Java<\/strong><\/h2>\n<p style=\"text-align: justify;\">You can also <strong>insert picture into MS Access\/SQL table <\/strong>using the Java program. For this, you need to make a table in your Access database. Do it as shown below:<\/p>\n<p><strong>Table Definitions:<\/strong><\/p>\n<table width=\"100%\">\n<tbody>\n<tr>\n<td>\n<table width=\"50%\">\n<tbody>\n<tr>\n<td><strong>Table Name<\/strong><\/td>\n<td>:\u00a0Img[InsertPicture.mdb]<\/td>\n<\/tr>\n<tr>\n<td><strong>Primary Key<\/strong><\/td>\n<td>: Nil<\/td>\n<\/tr>\n<tr>\n<td><strong>Foreign Key<\/strong><\/td>\n<td>: Nil<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>Column Definition:<\/strong><\/p>\n<table width=\"50%\">\n<tbody>\n<tr>\n<td><strong>Column Name<\/strong><\/td>\n<td><strong>Data Type<\/strong><\/td>\n<\/tr>\n<tr>\n<td>ID<\/td>\n<td>AutoNumber<\/td>\n<\/tr>\n<tr>\n<td>Images<\/td>\n<td>OLE Object<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>Table Description:<\/strong><\/p>\n<table width=\"80%\">\n<tbody>\n<tr>\n<td><strong>Column Name<\/strong><\/td>\n<td><strong>Description<\/strong><\/td>\n<\/tr>\n<tr>\n<td>ID<\/td>\n<td>Create AutoNumber for image id<\/td>\n<\/tr>\n<tr>\n<td>Image<\/td>\n<td>Image type &#8220;OLE Object&#8221;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>After creating the table now it\u2019s time to create the <strong>DSN<\/strong>. Make use of the following source code of <strong>InsertPicture.java.<\/strong><\/p>\n<blockquote>\n<p style=\"text-align: justify;\"><em>*\/<\/em><\/p>\n<p style=\"text-align: justify;\"><em>import java.io.File;<\/em><\/p>\n<p style=\"text-align: justify;\"><em>import java.io.FileInputStream;<\/em><\/p>\n<p style=\"text-align: justify;\"><em>import java.io.IOException;<\/em><\/p>\n<p style=\"text-align: justify;\"><em>import java.sql.Connection;<\/em><\/p>\n<p style=\"text-align: justify;\"><em>import java.sql.DriverManager;<\/em><\/p>\n<p style=\"text-align: justify;\"><em>import java.sql.PreparedStatement;<\/em><\/p>\n<p style=\"text-align: justify;\"><em>import java.sql.SQLException;<\/em><\/p>\n<p style=\"text-align: justify;\"><em>public class InsertPicture<\/em><\/p>\n<p style=\"text-align: justify;\"><em>{<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 public static void main(String[] args) throws Exception, IOException<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 {<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Class.forName(&#8220;sun.jdbc.odbc.JdbcOdbcDriver&#8221;);<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 String url=&#8221;jdbc:odbc:MyDsn&#8221;;<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0Connection conn=DriverManager.getConnection(url);<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 String INSERT_PICTURE = &#8220;insert into Img(ID,Image) values (?, ?)&#8221;;<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 FileInputStream fis = null;<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 PreparedStatement ps = null;<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 try<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0{<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 conn.setAutoCommit(false);<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 File file = new File(&#8220;laura.jpg&#8221;);<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 fis = new FileInputStream(file);<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ps = conn.prepareStatement(INSERT_PICTURE);<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0ps.setString(1, &#8220;001&#8221;);<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ps.setBinaryStream(2, fis, (int) file.length());<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ps.executeUpdate();<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 conn.commit();<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 finally<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 {<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0ps.close();<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0fis.close();<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }<\/em><\/p>\n<p style=\"text-align: justify;\"><em>}<\/em><\/p>\n<p>After then compile the above code by using the javac compiler. At the end run the program.<\/p>\n<p>C:\\jdk1.4\\bin javac InsertPicture.java<br \/>\nC:\\jdk1.4\\bin java InsertPicture<\/p><\/blockquote>\n<p style=\"text-align: justify;\">Now you will see the above code works great to insert a <strong>&#8220;laura.jpg<\/strong>&#8221; named picture within the image table.<\/p>\n<h2 style=\"text-align: left;\"><strong>Problems Associated With Image Insertion In Access Database<\/strong><\/h2>\n<p style=\"text-align: justify;\">Sometimes, it\u2019s not that easy to insert images into the Microsoft Access table. If you are inserting several images or each of the image files is quite large in size, then it automatically raises the \u201c<strong><a href=\"https:\/\/www.accessrepairnrecovery.com\/blog\/perform-easy-trim-operation-and-restore-databases-in-ms-access\">Access Database Too Large<\/a><\/strong>\u201d Issue. Well, to resolve this issue, just make use of Access&#8217; built-in utility tool, compact and repair. Otherwise, very soon your database will get corrupt.<\/p>\n<p style=\"text-align: justify;\">Unluckily, if you are already dealing with this Access database corruption issue. Then to get back your crucial data back make use of an outstanding <strong><a href=\"https:\/\/www.accessrepairnrecovery.com\/download-access-repair.php\">Access Repair And Recovery Tool<\/a>.<\/strong> It is the most prominent solution available to fix any corruption issue that occurred in Access database file ACCDB and MDB.<\/p>\n<h2 style=\"text-align: left;\"><strong>Related FAQs:<\/strong><\/h2>\n<h4 style=\"text-align: justify;\"><strong>Which Data Type Is Used to Insert an Image in an Access Table?<\/strong><\/h4>\n<p style=\"text-align: justify;\">Pictures, videos, sounds, and other binary objects (BLOBs) can be saved in\u00a0OLE objects\u00a0(Binary Large Objects) data type.<\/p>\n<h4 style=\"text-align: justify;\"><strong>What Data Type Is an Image in Database?<\/strong><\/h4>\n<p style=\"text-align: justify;\">The composite data type is an image in an Access database.<\/p>\n<h4 style=\"text-align: left;\"><strong>How Do I Insert an Image in Access Database?<\/strong><\/h4>\n<p style=\"text-align: justify;\">To insert an image in an Access database, follow the steps below:<\/p>\n<ul style=\"text-align: justify;\">\n<li>With the DB table that holds your attachment field open in the Datasheet view, double-click the attachment field.<\/li>\n<li>After this, click Add.<\/li>\n<li>Use the Look in list to navigate to the file(s) that you need to attach to a record, select the file(s) &gt;&gt; then click Open.<\/li>\n<\/ul>\n<h4 style=\"text-align: justify;\"><strong>Which Option Is Used to Insert Image?<\/strong><\/h4>\n<p style=\"text-align: justify;\">All you need to do is go to the Insert tab, then click Pictures. Browse your document where you need to insert a picture.<\/p>\n<h2 style=\"text-align: left;\"><strong>Time to Say Goodbye!<\/strong><\/h2>\n<p style=\"text-align: justify;\">So, this is all about <strong>how to insert image in Access database<\/strong>.<\/p>\n<p style=\"text-align: justify;\">Inserting photos into an Access database is straightforward. With the help of the right setup mentioned above, it becomes a quick &amp; easy task. Whether you use OLE Objects or Attachment Fields, pictures can significantly enhance your database\u2019s value.<\/p>\n<p style=\"text-align: justify;\">Stay organized, optimize your images, and enjoy a better-looking, more functional database!<\/p>\n<div class=\"su-note\"  style=\"border-color:#d9d9d9;border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#f3f3f3;border-color:#ffffff;color:#333333;border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;\">\n<p style=\"text-align: justify;\"><strong>References:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/answers.microsoft.com\/en-us\/msoffice\/forum\/all\/how-do-i-addinclude-photos-jpg-into-an-access\/ed7eaed5-670a-4229-9ce8-50797e658078\" target=\"_blank\" rel=\"noopener\">https:\/\/answers.microsoft.com\/en-us\/msoffice\/forum\/all\/how-do-i-addinclude-photos-jpg-into-an-access\/ed7eaed5-670a-4229-9ce8-50797e658078<\/a><\/li>\n<\/ul>\n<\/div><\/div>\n<div style='margin: 8px 0; clear: both;'><div style='border: 1px solid #e7e7e7; border-radius: 3px; background: #ffffff; color: #000; margin-top: 30px;'><div style='display: inline; background: #fff; padding: 10px; border: 1px solid #e7e7e7; border-bottom-right-radius: 10px; border-top-left-radius: 10px; border-top-right-radius: 10px; margin-left: -1px;'><img src='https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/12\/y-bulb.png' alt='tip' style='vertical-align: middle;' width='30px'><strong style='font-size: 18px; vertical-align: middle;'> Still having issues?<\/strong> Fix them with this Access repair tool: <\/div><div style='padding: 1rem; line-height: 1.6;'><p style='margin: 0; font-size: 17px;'>This software repairs & restores all ACCDB\/MDB objects including tables, reports, queries, records, forms, and indexes along with modules, macros, and other stuffs effectively.<\/p><div><ol style='font-size: 17px;'><li><strong><a href='https:\/\/www.accessrepairnrecovery.com\/blog\/get-access-file-repair-tool' target='_blank'>Download Stellar Repair for Access <\/a><\/strong> rated <i>Great<\/i> on Cnet (<i>download starts on this page<\/i>).<\/li><li>Click <strong>Browse<\/strong> and <strong>Search<\/strong> option to locate corrupt Access database.<\/li><li>Click <strong>Repair<\/strong> button to repair & preview the database objects.<\/li><\/ol><\/div><\/div><\/div><\/div>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>As we all know, Microsoft Access allows users to store images directly in their database. This feature is ideal for &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to Insert Image in Access Database? \u2013 (2025 Guide)\" class=\"read-more button\" href=\"https:\/\/www.accessrepairnrecovery.com\/blog\/how-to-insert-image-in-ms-access-database#more-65196\" aria-label=\"Read more about How to Insert Image in Access Database? \u2013 (2025 Guide)\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":65199,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[1978,1977],"class_list":["post-65196","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorial","tag-how-to-add-image-in-ms-access-database","tag-how-to-insert-image-in-access-database","resize-featured-image"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Insert Image in Access Database? \u2013 (2025 Guide)<\/title>\n<meta name=\"description\" content=\"Read this post to learn different methods to add image in Access database through attachments, OLE Object Fields, VBA code and more.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.accessrepairnrecovery.com\/blog\/how-to-insert-image-in-ms-access-database\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Insert Image in Access Database? \u2013 (2025 Guide)\" \/>\n<meta property=\"og:description\" content=\"Read this post to learn different methods to add image in Access database through attachments, OLE Object Fields, VBA code and more.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.accessrepairnrecovery.com\/blog\/how-to-insert-image-in-ms-access-database\" \/>\n<meta property=\"og:site_name\" content=\"MS Access Repair And Recovery Blog\" \/>\n<meta property=\"article:published_time\" content=\"2025-04-23T11:08:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-27T09:50:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/3-Easy-Ways-To-Insert-Image-In-Access-Database.png\" \/>\n\t<meta property=\"og:image:width\" content=\"850\" \/>\n\t<meta property=\"og:image:height\" content=\"450\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Pearson Willey\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Pearson Willey\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/how-to-insert-image-in-ms-access-database#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/how-to-insert-image-in-ms-access-database\"},\"author\":{\"name\":\"Pearson Willey\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/person\/9e865a2660c466b5b9c3a485e05f8ecb\"},\"headline\":\"How to Insert Image in Access Database? \u2013 (2025 Guide)\",\"datePublished\":\"2025-04-23T11:08:39+00:00\",\"dateModified\":\"2025-04-27T09:50:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/how-to-insert-image-in-ms-access-database\"},\"wordCount\":2187,\"publisher\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/how-to-insert-image-in-ms-access-database#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/3-Easy-Ways-To-Insert-Image-In-Access-Database.png\",\"keywords\":[\"how to add image in MS Access database\",\"how to insert image in Access database\"],\"articleSection\":[\"Tutorial\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/how-to-insert-image-in-ms-access-database\",\"url\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/how-to-insert-image-in-ms-access-database\",\"name\":\"How to Insert Image in Access Database? \u2013 (2025 Guide)\",\"isPartOf\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/how-to-insert-image-in-ms-access-database#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/how-to-insert-image-in-ms-access-database#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/3-Easy-Ways-To-Insert-Image-In-Access-Database.png\",\"datePublished\":\"2025-04-23T11:08:39+00:00\",\"dateModified\":\"2025-04-27T09:50:25+00:00\",\"description\":\"Read this post to learn different methods to add image in Access database through attachments, OLE Object Fields, VBA code and more.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/how-to-insert-image-in-ms-access-database#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.accessrepairnrecovery.com\/blog\/how-to-insert-image-in-ms-access-database\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/how-to-insert-image-in-ms-access-database#primaryimage\",\"url\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/3-Easy-Ways-To-Insert-Image-In-Access-Database.png\",\"contentUrl\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/3-Easy-Ways-To-Insert-Image-In-Access-Database.png\",\"width\":850,\"height\":450,\"caption\":\"3 Easy Ways To Insert Image In Access Database\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/how-to-insert-image-in-ms-access-database#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Insert Image in Access Database? \u2013 (2025 Guide)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#website\",\"url\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/\",\"name\":\"MS Access Repair And Recovery Blog\",\"description\":\"Your One Stop Destination for MS Access Fixes, Tutorials &amp; More\",\"publisher\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#organization\",\"name\":\"MS Access Repair And Recovery Blog\",\"url\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/07\/accessrepairnrecovery-com-logo.png\",\"contentUrl\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/07\/accessrepairnrecovery-com-logo.png\",\"width\":350,\"height\":70,\"caption\":\"MS Access Repair And Recovery Blog\"},\"image\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/person\/9e865a2660c466b5b9c3a485e05f8ecb\",\"name\":\"Pearson Willey\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1e14359741626aa0b5f1415dc1929323c9923a9826470b578bddbc2a39751640?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1e14359741626aa0b5f1415dc1929323c9923a9826470b578bddbc2a39751640?s=96&d=mm&r=g\",\"caption\":\"Pearson Willey\"},\"description\":\"Pearson Willey is a website content writer and long-form content planner. Besides this, he is also an avid reader. Thus he knows very well how to write an engaging content for readers. Writing is like a growing edge for him. He loves exploring his knowledge on MS Access &amp; sharing tech blogs.\",\"url\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/author\/pearson-willey\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Insert Image in Access Database? \u2013 (2025 Guide)","description":"Read this post to learn different methods to add image in Access database through attachments, OLE Object Fields, VBA code and more.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.accessrepairnrecovery.com\/blog\/how-to-insert-image-in-ms-access-database","og_locale":"en_US","og_type":"article","og_title":"How to Insert Image in Access Database? \u2013 (2025 Guide)","og_description":"Read this post to learn different methods to add image in Access database through attachments, OLE Object Fields, VBA code and more.","og_url":"https:\/\/www.accessrepairnrecovery.com\/blog\/how-to-insert-image-in-ms-access-database","og_site_name":"MS Access Repair And Recovery Blog","article_published_time":"2025-04-23T11:08:39+00:00","article_modified_time":"2025-04-27T09:50:25+00:00","og_image":[{"width":850,"height":450,"url":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/3-Easy-Ways-To-Insert-Image-In-Access-Database.png","type":"image\/png"}],"author":"Pearson Willey","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Pearson Willey","Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/how-to-insert-image-in-ms-access-database#article","isPartOf":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/how-to-insert-image-in-ms-access-database"},"author":{"name":"Pearson Willey","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/person\/9e865a2660c466b5b9c3a485e05f8ecb"},"headline":"How to Insert Image in Access Database? \u2013 (2025 Guide)","datePublished":"2025-04-23T11:08:39+00:00","dateModified":"2025-04-27T09:50:25+00:00","mainEntityOfPage":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/how-to-insert-image-in-ms-access-database"},"wordCount":2187,"publisher":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/how-to-insert-image-in-ms-access-database#primaryimage"},"thumbnailUrl":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/3-Easy-Ways-To-Insert-Image-In-Access-Database.png","keywords":["how to add image in MS Access database","how to insert image in Access database"],"articleSection":["Tutorial"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/how-to-insert-image-in-ms-access-database","url":"https:\/\/www.accessrepairnrecovery.com\/blog\/how-to-insert-image-in-ms-access-database","name":"How to Insert Image in Access Database? \u2013 (2025 Guide)","isPartOf":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/how-to-insert-image-in-ms-access-database#primaryimage"},"image":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/how-to-insert-image-in-ms-access-database#primaryimage"},"thumbnailUrl":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/3-Easy-Ways-To-Insert-Image-In-Access-Database.png","datePublished":"2025-04-23T11:08:39+00:00","dateModified":"2025-04-27T09:50:25+00:00","description":"Read this post to learn different methods to add image in Access database through attachments, OLE Object Fields, VBA code and more.","breadcrumb":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/how-to-insert-image-in-ms-access-database#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.accessrepairnrecovery.com\/blog\/how-to-insert-image-in-ms-access-database"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/how-to-insert-image-in-ms-access-database#primaryimage","url":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/3-Easy-Ways-To-Insert-Image-In-Access-Database.png","contentUrl":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/11\/3-Easy-Ways-To-Insert-Image-In-Access-Database.png","width":850,"height":450,"caption":"3 Easy Ways To Insert Image In Access Database"},{"@type":"BreadcrumbList","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/how-to-insert-image-in-ms-access-database#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.accessrepairnrecovery.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Insert Image in Access Database? \u2013 (2025 Guide)"}]},{"@type":"WebSite","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#website","url":"https:\/\/www.accessrepairnrecovery.com\/blog\/","name":"MS Access Repair And Recovery Blog","description":"Your One Stop Destination for MS Access Fixes, Tutorials &amp; More","publisher":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.accessrepairnrecovery.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#organization","name":"MS Access Repair And Recovery Blog","url":"https:\/\/www.accessrepairnrecovery.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/07\/accessrepairnrecovery-com-logo.png","contentUrl":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/07\/accessrepairnrecovery-com-logo.png","width":350,"height":70,"caption":"MS Access Repair And Recovery Blog"},"image":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/person\/9e865a2660c466b5b9c3a485e05f8ecb","name":"Pearson Willey","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/1e14359741626aa0b5f1415dc1929323c9923a9826470b578bddbc2a39751640?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1e14359741626aa0b5f1415dc1929323c9923a9826470b578bddbc2a39751640?s=96&d=mm&r=g","caption":"Pearson Willey"},"description":"Pearson Willey is a website content writer and long-form content planner. Besides this, he is also an avid reader. Thus he knows very well how to write an engaging content for readers. Writing is like a growing edge for him. He loves exploring his knowledge on MS Access &amp; sharing tech blogs.","url":"https:\/\/www.accessrepairnrecovery.com\/blog\/author\/pearson-willey"}]}},"_links":{"self":[{"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/posts\/65196","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/comments?post=65196"}],"version-history":[{"count":2,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/posts\/65196\/revisions"}],"predecessor-version":[{"id":69027,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/posts\/65196\/revisions\/69027"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/media\/65199"}],"wp:attachment":[{"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/media?parent=65196"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/categories?post=65196"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/tags?post=65196"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}