Solved

How to insert a bmp image into a SQL table through an MS Access project

Posted on 2012-04-12
4
333 Views
Last Modified: 2012-08-13
I am trying to create an interface on an Access form that allows the user to insert a .bmp image file into the database. I have created a varbinary(max) field in the table but have  no idea how to actually get the image to load. Thanks for any help
0
Comment
Question by:AkAlan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37838598
The only way that I know of to do this is with BLOBS
(B)inary(L)arge(OB)jects...
http://www.databasejournal.com/features/mssql/article.php/3719221/Storing-Images-and-BLOB-files-in-SQL-Server.htm
http://saveadba.blogspot.com/2012/02/import-blob-images-tsql.html
..et al

You can do a Google search of:
    SQL Server Store Image BLOB
...for more hits

Let's see what other Experts post...
0
 
LVL 6

Author Comment

by:AkAlan
ID: 37838793
OK, I got the image to store in the table, but I can't get it to display on an Access form. I dropped an Image control on the form and pointed it to the field with the bmp image but I just get a blank box when I open the form. Any ideas?
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
ID: 37839500
0
 
LVL 6

Author Closing Comment

by:AkAlan
ID: 37839641
Works perfectly,Thanks.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question