• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 831
  • Last Modified:

SQL Server Attachment Field like in Access 2007

Hi

In Access 2007 there is a special attachment field type.

Is it possible to replicate this field in a SQL 2005 database?
0
JoseJalapeno
Asked:
JoseJalapeno
  • 3
1 Solution
 
RiteshShahCommented:
well, you can get BLOB fields in SQL Server 2005. have a look at small demo created by me at .


http://www.sqlhub.com/2009/03/image-store-in-sql-server-2005-database.html
0
 
JoseJalapenoAuthor Commented:
I am using an Access 2007 front end
0
 
pcelbaCommented:
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.
0
 
RiteshShahCommented:
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.
0
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.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

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