i have a mdb - access2000 file with two tables.
i want to open both tables, and pass info between them.

i am having problems.... in access97 i used dao, it was easy.
in access2000 i use ado, and it is different.

can anyone explain, and/or send a code example......


to open one table i use the folowing code:

Dim cnn As New ADODB.Connection
Dim rs As New ADODB.Recordset

Dim DBFile As String
DBFile = App.Path & "\filename.mdb"

cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & DBFile & _
";Persist Security Info=False"

rs.Open "SELECT * FROM TableName", cnn, adOpenStatic, adLockOptimistic