Hi,

This may be an oledb driver related issue in your box.

Can you Reinstall MDAC and Jet SP8 in your box.

Click the following link to download latest SP for Microsoft...

Hi Jeff,

There is no harm by using Temp tables. I also use for most of my complex update & select queries.

May be if somebody is not using a stored...

Hi Ramesh,

Try the follwoing query

Select * from Employee

where slno

not in( select min(slno) from Employee group by name,ssn)

If the above select gives your duplicate records then replace the select statement...