Accessing a Lotus Notes 5 Database from MS-Access/Visual Basic
Posted on 2004-09-09
Hi, I need to access a Lotus Notes 5 database from MS-Access with Visual Basic. I'm looking for some kind of tutorial, where the complete process (opening the Notes DB, querying, accessing fields, etc., is described. Because of corporate restrictions, I have only access to the Notes 5 client on my machine, so all solutions needing access to the Notes Server are not possible.
I already found the Notes-Object availabe in the MS-Access Object Catalogue and started with the following code
Set session = CreateObject("Notes.NotesSession")
Set db = session.GETDATABASE("sstrda42.wk.dcx.com/Server/Prod/DCX", "aend_mgmt_sks.nsf")
Call db.Open("sstrda42.wk.dcx.com/Server/Prod/DCX", "app\019\tpc\pit\aend_mgmt_sks.nsf")
This doesn't produce any errors but trying to open a Notes View and accessing single fields always fails.
So any hint how to get the job done will be very much appreciated - thank you very much in advance.