A little code like this -----
Dim DB As DAO.Database
Set DB = Path to your external database
Dim Rst As DAO.Recordset
Set Rst = DB.OpenRecordset("Name Of Table In External database")
Now you can compare in a form that has its recordsource as the local
table ---
If Me!NameOfFieldInLocalTable = Rst!NameOfCorrespondingFieldInExternal Table
Finally Close DB and Rst
Rst.Close
Set Rst = Nothing
Set DB = Nothing
Steve
"Michiel Rapati-Kekkonen" <nn@nonsense.zzwrote in message
news:97***************@read4.inet.fi...
hi,
every now and then I want to compare a field in a local table to a field
in a table in another database.
but not by linking it permanently.
what would be the simplest approach
thanks for your suggestions
michiel