Document check in and out
Posted on 2011-09-12
Hi all - I have an IIS 7 web-site connected to an Oracle database which stores MS Office documents. Users need to login to the site and are presented with a list of documents associated with a customer which they should be able to open read-only, or if they wish, should, check out the document for modification and when finished the document should be automatically uploaded back into the database.
Problem number 1 is that I do not want to leave a copy of the document on the local machine, and I cannot rely on the user to remember to delete the document so it needs to be automatically removed post upload.
Problem number 2 is the users will probably not remember where they downloaded the document to on the local machine, so the ASPX page would need to remember where to upload the document from.
I am currently looking at developing an Active X control to handle this, but that restricts the user to using Internet Explorer.
A Java applet which would auto-install may work but have no development experience in this.
Browser specific plug in's may be able to work, but again - no experience in this either.
A client executable could be made available for the user to download but that seems very messy.
Basically, I am hoping someone out there has had this problem and solved it either through custom developed code, or a commercial app. The documents need to remain in our internal database and accessed through the web server... ie: storing the documents in a cloud for on-line editing is not an option. Also - need the approx 250 users to be able to access and edit the documents through their iPads ideally, although that is something I am happy to postpone to a later date.
Thanks in advance for any advice!