SQL Server Attachment Field like in Access 2007


In Access 2007 there is a special attachment field type.

Is it possible to replicate this field in a SQL 2005 database?
Who is Participating?
RiteshShahConnect With a Mentor Commented:
I don't know how to do it from access but I saw you the way that this is possible in SQL Server from via C# and if you directly want to do it in SQL Server than there is one post of "Lam" who has upload image to SQL Server and got it back from SQL Server itself, you might use that with ACCESS. I don't know how to do it especially from ACCESS.
well, you can get BLOB fields in SQL Server 2005. have a look at small demo created by me at .

JoseJalapenoAuthor Commented:
I am using an Access 2007 front end
SQL Server has restricted support for this functionality and you'll need some front-end programming to implement it similar way. SQL Server allows to store binary data in varbinary and image columns but Access allows more attachements in one field and it is not easily portable to SQL Server.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.