• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 826
  • 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

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

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