Connecting LotusNotes with MS Access 2000

[t1hodges]

Does anyone have experience conecting access databases to LotusNotes databases? I want to either push data from access to LN or from LN to access, which ever is easiest. Actually I would rather push to LN. Any advise is appreciated. Im currently using access 2000 in winnt and lotusnotes 6.5 but my company is migrating to winxp pro and office xp in about three months.

 

[willir]

t1hodges

ADO ODBC connection DSN-less...
ODBC Driver for Lotus Notes
... if you know what your are doing.

ODBC driver
NotesSQL from IBM
... allows you to link to views of the Notes database. (You will have to register)

And some good Tek-Tip posts...
Lotus: NotesDesigner Forum
Need Access to grab data from Notes database (see LesPaul's fabulous posts)
Linking Access with Lotus Notes - please help!
Getting data from lotusnotes db--Clueless!!

I am still struggling with my project, but this is more of an issue with trying to do what I need to without sufficient access rights.

Richard

 

[t1hodges]

thank you willir. I'll review the links.

 

[t1hodges]

Hey willir

IBM site doesnt have the notesql driver 3.02. Any Idea of where to get it? Im running notes ver 6.5

 

[lespaul]

did you try notes.net?

Leslie

 

[t1hodges]

I have not. Doing it now.

 

[t1hodges]

I take that back. That link routed me back to the IBM site and I've already search it to no avail. Any other ideas?

 

[lespaul]

I googled for NotesSQL driver 3.02 and found this download page:

http://www.lotus.com/products/product4.nsf/wdocs/3243f3d81944584085256e20006db691

Leslie