0 Replies Latest reply on Nov 1, 2010 11:00 AM by mark_d2x

    OLE to word documents on server



      OLE to word documents on server



      I need to connect my database to a shared folder on a server to OLE the word documents.

      What I have done so far is set a text field with the file path ....    

      folder= filewin:\\server\ as a global field.  

      I have then created a calculation field to

      folder & HOSPITALNUMBER::hospital number & ".doc" to give the full filepath ie filewin:\\server\123467H.doc

      I don't knowif I should  use a container field or web viewer to display the word document as an object - any suggestions?

      The folder in question has about 18, 000 word documents in it and eventually I need to replicate this to at least another 6 locations for varying documents with about as many documents in each.  What I really don't want to be doing is have to search for each individual file and go through the dragging and dropping documents into the database as there are roughly 2000 x 6 records and growing.