Open, Edit and Save Word/Excel Files

Question

User-697123544 posted

Dear All,<o:p></o:p>

We are in the process of developing an asp.net application. The application is a web based document management system. The system architecture is as follows:<o:p></o:p>

1. Webserver running on IIS and ASP.NET - This will host the front end application where the user shall interact with the system<o:p></o:p>

2. Application Server (VB.NET) - This is the middle tier server which is a customised Application server developed in VB.NET is the main server which handles all business logic actions and further process including indexing<o:p></o:p>

3. Storage System – This is the dB tier and is divided into two segments:<o:p></o:p>

            A. DB Tier – This is the back end data storage system running of SQL Server 2010<o:p></o:p>

            b. File system – This is the file space (files, folders, etc.) on the hard disk where all documents are saved.<o:p></o:p>

Kindly note that the documents are not saved to the database but only location of the file is saved to database.

We have hit a road block half way down the line. The problem now we are facing is the user who works the document is required to open, edit and save the file back to server.

We are not sure how to achieve this. We are okay with the end user download the file to their system and then editing, but however, the user must mandatory forced to upload the edit document which is impossible in the web environment.

Any suggestions are welcomed.

Thanks and regards,<o:p></o:p>

 --

Sridhar

Answer 1

User-183374066 posted

May be you heard about sharepoint. Actually you are looking something sharepoint do like someone access his documents, open it, do some changes and save back to the server. I believe this is very hard to workable in asp.net site. 

You can use some third party controls e.g. for word see

You might be not using sharepoint as it is costly :)

Answer 2

User-697123544 posted

Dear Nasser,

Thanks for the info. We are not planning to use MS sharepoint. Will I be able to create a tunnel using the application server, to access the file. Or can i make use of network sharing in someway to achive this result.

Thanks and regards,