Read Write BLOB MSACCESS SQL Server

[humpydumpy2000]

Hi all,

I have a linked table where I want to save images in SQL server. I am using MSaccess as front end.

Any ideas how am I going to store, read BLOBS?

I found this article

https://support.microsoft.com/en-us/kb/103257

but am still clueless how am I going to implement it.

Thanks in advance

 

[strongm]

Have a look SQL Server's VARBINARY type. Or, if on SQL 2012 or later, perhaps look at FileStreams and FileTables

SQL Server also has a Image data type, but it is deprecated.

 

[humpydumpy2000]

^^I already know about that, my problem is when I select file ex(img.jpg) how am I going to write a blob on a On Click event using

https://support.microsoft.com/en-us/kb/103257?