Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Mar 2009
    Location
    Hong Kong
    Posts
    359
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Is it practical to store all Outlook items (appointments, tasks, emails, notes) in Access database for rapid search and retrieval?

    Armstrong

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Outlook itself has various search options (simple and advanced).

    Importing all Outlook items into Access seems overkill to me. If you wish, you can link Outlook folders into an Access database (File | Get External Data | Link Tables...)

  3. #3
    3 Star Lounger
    Join Date
    Mar 2009
    Location
    Hong Kong
    Posts
    359
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='783450' date='08-Jul-2009 13:48']Outlook itself has various search options (simple and advanced).

    Importing all Outlook items into Access seems overkill to me. If you wish, you can link Outlook folders into an Access database (File | Get External Data | Link Tables...)[/quote]
    The idea stems from enormous number of Outlook items being kept in the PST. It's extremely sluggish to retrieve records. Even switching folders, say from email to appointment, would take over 3 seconds. Perhaps, Access may be a solution to manage a huge number of Outlook items.
    I wonder if any members of Woody's Lounge actively use Access to manage Outlook items.
    Armstrong

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    It depends on what you want to do with the items. If you import Outlook items into Access, not all properties will be imported, so you'll miss some information in Access.
    Also, an Access database has a maximum size of 2 GB, while an Outlook .pst file in Unicode format can be up to 20 GB, so if you have a very large .pst file, you may have problems importing everything into Access.
    You may be better off archiving some of the items to a separate .pst file.

Posting Permissions

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