Solved

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

Posted on 2012-04-12
4
338 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

Enroll in July's Course of the Month

July's Course of the Month is now available! Enroll to learn HTML5 and prepare for certification. It's free for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

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

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

628 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