Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Posts
    2

    Unanswered: Attaching Documents

    Simple question guys, which im starting to guess may be answered with a simple no.

    Is there an easy way to attach word documents to an simple access database? Currently I have a field with links to the original file on my pc's hard drive. However I need to distribute this as a read only db, and we dont have share point or anyother LAN based group working software. I want a field that contains for example, the name of a file, and when this is clicked on, that documnent opens in ms word, but the document has to be stored somewhere inside the db, and not is a separate folder.
    Incase it isnt obvious Im not a programmer / db developer (i.e newb)
    all help appreciated, if its not possible a simple no will suffice
    thanks in advance chaps
    Nick

  2. #2
    Join Date
    Feb 2004
    Posts
    142
    The memo field can be utilized to store RTF docs. Not perfict but it will allow for storage.
    KC

  3. #3
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Only drawback to the Memo field is the 64K size limit ... You might want to consider using an OLE Object type ...

  4. #4
    Join Date
    Feb 2004
    Posts
    2
    Ok, took your advice, created an OLE field, but when i got to

    insert object - create from file - choose appropriate file

    'word document' appears in the field. But when i try to save,
    or click on the cell to open the document i get following message

    'a problem occured while access was tring to communicate with the OLE server'
    Im not even trying to connect to a server

    Am i doing something (or not doing something) wrong or is it just not possible
    Once again, thanks for previous help, and further help MUCH appreciated
    Nick

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •