Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 367
  • Last Modified:

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

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
AkAlan
Asked:
AkAlan
  • 2
  • 2
1 Solution
 
Jeffrey CoachmanCommented:
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
 
AkAlanAuthor Commented:
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
 
AkAlanAuthor Commented:
Works perfectly,Thanks.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now