Using Access as a Front End for Document Management

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Trying to develop a poor man's version of LiveLink or SharePoint. I can
create a link to an external file and open the file from Access, but I cannot
seem to control if the file is opened read-only or read-write. Ideas? My
desire is to allow users to open and view a Word or Excel file, for example,
but not be able to modify the file. In cases where the file is being
"routed" for revie wand comment, then they can modify the file.
 
There may well be a better solution but I have used the SetAttr command to
make files read-only prior to opening. Eg.:

SetAttr strFilePath, vbReadOnly
 
Back
Top