Compare fields from two different databases

[ppataki]

Dear All,
I have two databases with one table being the same (ie. same table name, same field name)
and contains only one record
How could I compare the content of those records (record has only one field) without linking the table to the database?
I started to write a code but I am stuck here:

Dim dbOther As DAO.Database
Dim rsOther As Recordset
Set dbOther = OpenDatabase("[URL="file://\\hubuwfpa01\cp$\For"]\\hubuwfpa01\cp$\For[/URL] Non (only) Finance\Elszámolások\Havi elszamolas sablon.accdb")
Set rsOther = dbOther.OpenRecordset("tbl_timestamp", dbOpenDynaset)

and from here I would need to compare rsother with the same recordset of the currentdb

Many thanks in advance

 

[Guus2005]

Use a query with a remote database connection like this to retrieve the data

SELECT * FROM SomeRemoteTable IN 'P:\RemoteDB.mdb'

I can't think of anything more to write to clarify the above code so i won't.

Enjoy!

 

[ppataki]

This works perfectly!!!

Many thanks!!!