How to save file (doc,pps, exe...) in SQL database

[tb2007]

I have application in VB/SQLServer. I have table like this:

Id
Date
To
From
Attachment
Text

My client wants to have something like MS Outlook in this VB application. He wants to send some files (mp3,doc,txt, pps,.....etc) via SQL. He wants these files to be saved in SQL database, not in the file folder on HD. He wants to read, write, and delete these files from SQL.
How to do this in VB?

 

[HarleyQuinn]

A quick search on this forum turned up this (thread222-753300) where strongm's posts might be something like what you are after.

Hope this helps

HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.