Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Oct 2001
    Location
    Newport, Gwent, Wales
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access 'talking to' Lotus Notes (Access 2k Win 2k Notes version 5)

    Dear All

    I've been asked to look at pulling together several data sources, one of which is a Lotus Notes database.

    I don't really want to replace the Notes system as it is well established and the users like it, what I want to do is read the data in the Notes system and work with it using read only queries.

    Has anyone had previous experience of this sort of task? Also, considering my lack of knowledge and expertise, is it likely to be achievable?

    Thanks

    Ian

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

    Re: Access 'talking to' Lotus Notes (Access 2k Win 2k Notes version 5)

    The users *like* it? If so, that's the first time I've heard that phrase applied to Lotus Notes! <img src=/S/yikes.gif border=0 alt=yikes width=15 height=15> Do you have any idea what the file format is? Is the database using Approach or something contained completely within Notes? In either case, it's likely you would have to export data from that database into a format Access can handle. It is not likely you can just connect to it, but ADO may be able to retrieve the data if there is an OLE DB driver for the Notes database.
    Charlotte

  3. #3
    3 Star Lounger
    Join Date
    Oct 2001
    Location
    Newport, Gwent, Wales
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access 'talking to' Lotus Notes (Access 2k Win 2k Notes version 5)

    OK, so 'like' might not be the best description, but they are used to it and can manipulate it at high speed (for data input) due to the familiarity with the system. The problem comes when some one wants to analyse the data in the system, they can't really do anything useful with it.

    I was thinking that maybe the OLE DB option would be a possible solution, but so far haven't found any reference to a driver.

    I'm thinking that this project may be one to leave alone until it quietly dies in a corner, or they get some one qualified to do it instead <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

  4. #4
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Atlanta, Georgia, USA
    Posts
    274
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access 'talking to' Lotus Notes (Access 2k Win 2k Notes version 5)

    Dazed,
    I got the ODBC drivers off of the IBM web site to connect to a Lotus Notes database. You have to have permissions to the particular database in Notes that you want to connect to. I think Notes 5 encrypts the actual email message if that is what you were trying to look at. The calendar and to do lists are all readable. When I get back to the office tomorrow I can point you to the download for the drivers

  5. #5
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Atlanta, Georgia, USA
    Posts
    274
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access 'talking to' Lotus Notes (Access 2k Win 2k Notes version 5)

    (Edited by HansV to activate URL - see <!help=19>Help 19<!/help>)

    Dazed,
    Here is the link to download the NotesSQL 3.02 ODBC Driver: NotesSQL

Posting Permissions

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