<div>
Lotus Notes uses VBA as the Scripting language (yes that's right--VBA, just like in Excel, or Access). &nbsp;Hence you can write NotesScript (which I belive is the name that LOTUS uses for the Scripting tool - but it IS LICENSED VBA from Microsoft), and then you can use either DAO or ADO to connect to the Access database, in your script code.<br />
<br />
<br />
Arthur Wood<br />

</div>


Lotus Notes uses VBA as the Scripting language (yes that's right--VBA, just like in Excel, or Access).  Hence you can write NotesScript (which I belive is the name that LOTUS uses for the Scripting tool - but it IS LICENSED VBA from Microsoft), and then you can use either DAO or ADO to connect to the Access database, in your script code.


Arthur Wood


<div>
Would there be an easier way ...ie odbc<br />
<br />
I want to see a Notes DB from Access.....<br />
<br />
if possible ;-)<br />

</div>


Would there be an easier way ...ie odbc

I want to see a Notes DB from Access.....

if possible ;-)


<div>
You can get the NotesSQL ODBC
</div>


<div>
Here's a more direct URL:<br />
<br />
<a href="http://www.lotus.com/developers/devbase.nsf/homedata/homensql" rel="ugc">http://www.lotus.com/developers/devbase.nsf/homedata/homensql</a><br />

</div>


Here's a more direct URL:

http://www.lotus.com/developers/devbase.nsf/homedata/homensql [http://www.lotus.com/developers/devbase.nsf/homedata/homensql]


<div>
<br />
No comment has been added lately, so it's time to clean up this TA.<br />
I will leave a recommendation in Community Support that this question is:<br />
&nbsp;- Answered by: mgrattan &nbsp;<br />
Please leave any comments here within the <br />
next seven days.<br />
<br />
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !<br />
<br />
Nic;o)
</div>



No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in Community Support that this question is:
 - Answered by: mgrattan  
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Nic;o)

<div>
Per recommendation, force-accepted.<br />
<br />
Netminder<br />
CS Moderator
</div>


Per recommendation, force-accepted.

Netminder
CS Moderator

<div>
<div class="content wysiwyg-content">
any ideas experts? Ive seen come commercial products for this but there has to be some odbc driver.<br />
<br />
Ive seen the notespump but this is from something to Notes.....<br />
<br />
Any ideas?<br />
<br />
Thanks in advance !<br />
<br />
Steve
</div>
</div>


any ideas experts? Ive seen come commercial products for this but there has to be some odbc driver.

Ive seen the notespump but this is from something to Notes.....

Any ideas?

Thanks in advance !

Steve

How do i connect Access to Lotus Notes with ODBC

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.