Multiple Databases

[nysmile]

I am using two databases - oracle and SQLServer. I have two recordsets, rs. and rss. Now I need to validate rs.fields("Employee") = rss.fields("Employee") and create a report with the error message that the record containing the field in rs.fields is missing. Can anyone help???? I'm new at programming code in VB.

[srinika]

Use seperate DSNs for the 2 databases.
Also have 2 seperate connections.

Get all records of the 2 tables in to a 2 recordsets (As u have done)
Have 2 loops, Inner & Outer.
Get each record in the outer loop and check with each rec in the inner loop whether they match or not. In the loop do whatever u wish.
(ie, error msg ... or anything)

That's it
If u want the logic to be written I can do but I'm quite busy now!!
Good Luck
Srinika