I have a doctors office as a client that is using a mssql and msaccess databases to store information. They are wanting to be able to transfer information from the mssql database to the msaccess database in real time. I wrote a query to insert the information from the mssql database to the msaccess database but now i need a way to search the access db for duplicates and remove them. IT has to be a permanant solution, data is imported daily from the mssql database, I need a solution that will stay in place. I also wrote a append query to add information from dbo_patient (mssql, import) to my "Patients" table (Access) each time its ran it creates duplicates of every patient, I need a way to run it once a day and replace or overwrite the patients already there instead of duplicating them, i can run a delet query but not all fields are identical from mssql and the access databases, so if i delete all, then it erases any new data placed in the "patient" table from access. Any and all help would be appreciated. Thank you.