Use MS Access 97 to query Lotus Notes database

[Klopper]

Hi

I would like to use MS Access 97 to query a Lotus notes database...is this:
a) feasible, and if so
b) difficult, and if so
c) reasonable?

Why do I ask? I have built a reporting suite for my department in MS Access 97 but there is a legacy Lotus Notes Database which need I also need to query. I have used ODBC links to Oracle / Sybase / SQL Server etc but not Lotus.

Any thoughts appreciated!

 

[Klopper]

Just an update,

is very possible, but you need to have the NotesSQL ODBC driver installed.

see:

http://doc.notes.net/notessql/3.0/n...b0102b9c394ea2cf052569d6005e9dd5?OpenDocument