Link to home
Start Free TrialLog in
Avatar of AkAlan
AkAlan

asked on

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
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

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...
Avatar of AkAlan
AkAlan

ASKER

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?
ASKER CERTIFIED SOLUTION
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of AkAlan

ASKER

Works perfectly,Thanks.