asked on

NotesSQL ODBC problems with Access

I have the NotesSQL ODBC driver on my PC (Win95, Office 95).
I can get access to LotusNotes databases from Excel via MSQuery - it invokes DOS window with information about name of *.id file and prompts me for password. All works fine. But when I try to do the same with MSAccess 7.0 (95) - appear same DOS window (conagent.exe) but without any information, any prompt and any action on keypress. Access waits for response...And as I know, on Win NT systems Access works well with this ODBC driver. Can anybody help me?

rloomis

One possible factor: do you have the 'share password with add-in tasks' checked in Files Tools UserID Basics?

vboukhar

ASKER

Thanks for reply, but problem still exist if this option checked or not. Have you any other suggestions?

ASKER CERTIFIED SOLUTION

phooey

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

vboukhar

ASKER

Thanks, phooey, I'll try first method, but I have to use only second one - get data from Notes database from Access. I've made ODBC source using Notes SQL driver already and when I try query it from Access, appear black DOS-window (conagent.exe) and Access hung up. I use Win95. What system do you use? I know, that on Win NT system DOS window don't appears, and password query window is stadart Window form, so there isn't any problem at Win NT computer to get direct access to Notes database via Notes SQL ODBC source. Why not in Win95?...
In any case, I'll try Notes to Access and I'll post results here.
Thanks!

vboukhar

ASKER

phooey!
Could you give me brief instruction - how to read and write to ODBS data source (f.e. Access database) from within Notes? I use Lotus Notes 4.5 I've tired to find way how to do that. Maybe I have to be an administrator?

vboukhar

ASKER

phooey!
I've found how to use ODBC from Notes to Access by myself (via scripting). In any case, thanks for help!