Results 1 to 6 of 6
  1. #1
    Lounger
    Join Date
    May 2001
    Location
    Wellington
    Posts
    35
    Thanks
    0
    Thanked 0 Times in 0 Posts

    RTF or HTML in Access table (97/2k)

    I wondered if anyone had experience or suggestions for storing formatted data in an Access table. The specific requirement is for storage of short stories, including italics, bold etc. Any pointers would be most appreciated.

    Cheers

    Jim

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: RTF or HTML in Access table (97/2k)

    You can't do it with native Access, although there are some third party custom controls that might work. You can store Word documents in an Access table but it isn't recommended because the size can get out of hand quickly. The usual alternative is to store links to documents or OLE objects.

    What is the purpose in trying to store the documents in Access?
    Charlotte

  3. #3
    Lounger
    Join Date
    May 2001
    Location
    Wellington
    Posts
    35
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: RTF or HTML in Access table (97/2k)

    I'm using the content to build a static, occasionally updated website. I guess links might do the trick...

  4. #4
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: RTF or HTML in Access table (97/2k)

    You can store tagged text (e.g., with [i] and [b] tags) in the database. The trick then is to get ASP or whatever serving technology you are using to interpret it properly. When I try this with FrontPage's database webbots, they HTMLencode it so that it appears with the tags in the page rather than formatting it. Not helpful, but maybe fixable. YMMV.

  5. #5
    Giovanni
    Guest

    Re: RTF or HTML in Access table (97/2k)

    I once created an application for a lawyer who absoluteley wanted to store contracts and correspondance inside ACCESS tables. The standard ACCESS OLE server makes the table explose. So I searched for third party solution and I found a wizard that does avoid the bloating effect (works with .DOC, .RTF, .DOT...) and easy to use. Its name is "WordWithACCESS" and you find it on the "ACCESS Powerups" link page of www.unsoftwareag.com.

  6. #6
    2 Star Lounger bobdog's Avatar
    Join Date
    Jan 2001
    Posts
    108
    Thanks
    3
    Thanked 5 Times in 4 Posts

    Re: RTF or HTML in Access table (97/2k)

    This is an old thread, so I don't know if I'm wasting my time or not with a response.

    FMS has a Rich Text Tool that works well and is sold as a separate product. There is also a rich text control (on which the FMS tool actually acts as a wrapper). Price for the FMS tool is $299, as I recall. The MS rich text tool is either in the Office Developer toolkit or in Visual Studio, as I recall. Functionality is very similar to the features found in WordPad (fonts, colors, hyperlinks, etc.) and includes an optional spell checker.

    I haven't used it with '97, but have with 2K. If you do use 2K, you must have SR-1 installed (there's a bug in the MS RichText tool that SR-1 fixes).

    With FMS, you can get at both the formatted text and the raw text in code. The raw text looks much better on forms, and the formatted text looks good in reports.

    If you're doing a lot of editing, pay attention to file bloat, which is related to the use of memo fields, not the use of the RT tools.

    If you need to protect the content of these stories, you might look into Adobe's PDF writer, storing the documents in PDF image form that can be emailed, printed, searched, etc. You create these files by "printing" to the PDF writer from Word, which gives you all the editing and formatting features of Word, and you don't have to worry about file bloat, no matter how many documents you've got.

Posting Permissions

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