Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Nov 2007
    Thanked 0 Times in 0 Posts

    Access 2003 how do i Add personal word docs to data type or field properti

    Hi there

    I am using Access 2003 and have 200 clients I am adding field names and data types and want later on to be able to use the table or a sub-form in forms to up-load each individuals personal word doc CV to there personal sub-form record. Do I set this early on in data type or field properties or use OLE to look up there record on the server depending on the clients name or automated client number? If so how exactly can I do this if it can be done. I only have basic college knowledge of Access so do not know any programming. I realise this can be done in Excel but my boss wants if possible to have the information at hand in a sub-form personal record ready possibly by accessing it via a control button so once clicked the CV will appear for that client and every client once viewing their record details.

    Thank you

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Evergreen, CO, USA
    Thanked 65 Times in 64 Posts
    There are several approaches to this problem. One is to actually store the Word doc in the Access table as an OLE object - you specify a field in the table that way. Another option is to store the path to the Word Doc as a string in a text field - that has some advantages in that you can open the object without going into the database should you wish to. A third option is to actually extract the text from the Word doc, and store that in text fields or memo fields, but that will loose the formatting of the Word doc, even if you construct an Access report to display the data. A more sophisticated approach would use "Automation" to actually manipulate the Word doc from Access, but that involves extensive programming using VBA to manipulate both the Access Object Model and the Word Object Model. My inclination would be to use the OLE object in the Access table since you don't have much experience with Access VBA programming. Let's see what others suggest.

  3. #3
    WS Lounge VIP
    Join Date
    Jun 2010
    Thanked 1,421 Times in 1,232 Posts
    Personally I prefer keeping such files outside the database, as Wendell suggests in his 2nd option or using an hyperlink field, to link to the file directly. Using a text field is harder to handle programatically, the hyperlink field not so much, as you can simply click it to open the doc.
    Last edited by ruirib; 2011-12-14 at 10:30.

  4. #4
    3 Star Lounger HiTechCoach's Avatar
    Join Date
    Sep 2011
    Oklahoma City, OK
    Thanked 37 Times in 36 Posts
    Storing file in an Access 2003 data will cause considerable bloat in size. You could possible exceed the 2 gig file size limit with 200 Word documents stored in the database.

    I avoid the hyperlink data type. I have had issue with it. See: Hyperlinks: warnings, special characters, errors

    I have created an example of how I prefer to handle this: Document Links and Document Links 2
    Boyd Trimmell aka HiTechCoach (Access Information here)
    Microsoft MVP - Access Expert
    "If technology doesn't work for people, then it doesn't work."

Posting Permissions

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