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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Works perfectly,Thanks.
(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...