Access 97 on Win XP Pro (SP1), NotesSQL 3.02e, Notes Client 4.6.7a.
I am trying to connect to a networked Domino server to pull some data in to Access 97 with the following VBA code:
Dim con As ADODB.Connection
Set con = New ADODB.Connection
con.Open "Driver=Lotus NotesSQL Driver (*.nsf);Database=TEST.NSF;Server=Domino1;UID=Alan Craig;PWD=password;"
When logged on as local administrator (workstation only) everything works fine. When I log on to the windows domain as a user with local administrator rights I receive the following error message:
-2147217843 [Lotus][ODBC Lotus Notes]Driver not capable.
I also get the same message if I use a DSN.
Has anybody got any ideas?