ado question

[mrz]

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

[Whitebat]

so far your code looks right so just define your problem so i could help you

[Whitebat]

ps: Why don't to make a select statement like this ?
Select t1.this t2.that
from table1 t1, table2 t2
where
and
.
.
.
??

[mrz]

i am getting unusual errors on things like:
rs.edit, or with block undefined... on things that worked well with access97 and dao, things that dont work now.

[Whitebat]

as you now it is microsoft and especially adodc ado dbgrids flexgrid are causing problems all the time . Sometimes it helps when you update your service pack for vb
on the errors you get i can't say s omething because i don't have the code if you want to you can write me a mail and i try to help you