Storing documents in SQL server (word, excel, etc), allow edits?

[ordendelfai]

I found an article from Microsoft that talks about storing Word docs in the server by using the Image type.

http://www.microsoft.com/sql/techinfo/tips/administration/importword.mspx

I have seen applications that let users store documents in a grid (row by row) and allow the user to open the documents, edit/save/close and the changes either overwrite the version on the server, or edit it directly.

I am attempting to duplicate this feature and have no idea where to start. I am hoping someone can point me in the right direction. Is there any ActiveX objects that can do this?

~Joel
As common courtesy and to help other members who might find your thread helpful in the future, please respond if the advice given resolved your issue.

 

[mrdenny]

You'll want to ask the front end folks. This would all be handled on the front end, then the data would be sent back to the SQL Server as a binary string.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[ordendelfai]

Hmm, I may repost in the VB forum, however, can you elaborate on the binary string? Is there a command I can run from query analyzer to dump a file into an image field, and another command to export it out?

Is it even possible to export it out and open it as a editable word document? The "Image field" makes me think that it stores it as an image, so getting it back out to edit as a word doc is not possible. Maybe I misunderstand what the Image field is doing though...

Confused,



~Joel
As common courtesy and to help other members who might find your thread helpful in the future, please respond if the advice given resolved your issue.

 

[mrdenny]

The image data type is mis-leading. All it means is that the data in the field is stored in a binary form up to 2 GB per record.

To put data into an image field through QA you'd be using a insert statement just like any other data. To do this with files, and keep them intact you'll need to use ADO functions that aren't available from QA.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)