How to identify duplicate records in 2 databases

[Roy]

Hi all,
My task is to identify duplicate records in 2 tables that each located in
different Access database. These tables have exactly the same structure. My
immediate response was to create two datasets from each table and loop
through one and compare it with another one, but I'm sure there are better
way to this.
Any suggestions is appreciated.
Roy

[Carlos J. Quintero [.NET MVP]]

I am not sure if it works, but if Access supports remote joins (attaching a
table from other database), that would be better.

--

Best regards,

Carlos J. Quintero

MZ-Tools: Productivity add-ins for Visual Studio .NET, VB6, VB5 and VBA
You can code, design and document much faster.
Free resources for add-in developers:
http://www.mztools.com

"Roy" <Ro*@discussions.microsoft.com> escribió en el mensaje
news:14**********************************@microsof t.com...

Hi all,
My task is to identify duplicate records in 2 tables that each located in
different Access database. These tables have exactly the same structure.
My
immediate response was to create two datasets from each table and loop
through one and compare it with another one, but I'm sure there are better
way to this.
Any suggestions is appreciated.
Roy