LotusScript & ADO

[Rick Hinze]

Greetings!
Can someone provide help with using LotusScript and ADO to make a DSN-less
connection to an Access table? I need to send a SELECT statement and return
a recordset.
TIA,
Bo Billy
<remove NOSPAM from email>

[Tom Dierickx]

Actually, it's rather easy!

Check Out: http://msdn.microsoft.com/library/psdk/iisref/iiwadata.htm for
details.

Example:

Dim cnn As ADODB.Connection
Dim rst As ADODB.Recordset
Dim strSQL As String

Set cnn = CreateObject("ADODB.Connection")
Set rst = CreateObject("ADODB.Recordset")

cnn.Provider = "Microsoft.Jet.OLEDB.4.0"
cnn.Open "C:\Windows\Desktop\test.mdb", "Admin", ""

strSQL = "SELECT * FROM [Table1]"
rst.Open strSQL, cnn, adOpenForwardOnly, adLockReadOnly

"Rick Hinze" <rhi...@NOSPAM.hinzesight.com> wrote in message
news:tc1bok8...@corp.supernews.com...

[Rick Hinze]

Excellent!
Thanks, Tom!
"Tom Dierickx" <dier...@healthyexchanges.com> wrote in message
news:_acw6.166302$t67.2...@news1.rdc1.il.home.com...