This will take some explaining and I'm just a casual SharePoint user,
so have mercy on me, OK?
We want to have some Word documents in a SP site, with a broad group
able to search them, but a smaller group able to edit them. To my
knowledge, that's certainly doable.
These Word documents will contain lists of certain things that have
to be done by certain dates. There will be a database that contains
these 'Action Items' and their 'due dates' - the entry of the Action
Items and due dates will be a manual operation. The database will
probably start life as an Access database, but will either be moved
to SQL Server or (much less probably) into SharePoint lists (the back
end of the database).
Now the tricky bits. When an actual completion date is entered for
one of the Action Items, a programmatic series of actions needs to
add a text string to the appropriate Word document.
If SQL Server has been used, a table trigger can be set up to run an
external executable, but the issue then becomes: can SharePoint be
automated to select a file, programmatically open it, insert/append
text and then close the file? Note that this would be done by an
external program, which could lead to all sorts of possible
permission issues. Anyone ever done this sort of thing?
As an alternate, if the back end of the SQL Server database was
implemented as SharePoint lists, could a SharePoint workflow be
configured and triggered by a list item receiving a value - and the
necessary actions of opening up a Word document, adding (appending or
inserting) text and then saving it - be done as part of the workflow?
Or, am I totally out in left field with this concept? Any insights
anyone might have would be most appreciated...