works perfect in access97 and access2000

and it is FAST, have I mentioned that you are the MAN!!

I haven't tested using just the runtimes, since HQ has upgraded Office std to Office Pro, so I'll just deploy access97 to the clients needing this functionality.

I'm gonna add some backup procedures to it, like copying the DB before I update the table (for CYA)

BTW, is there a function that calls record count of the table? like check the number of records in the 2 tables, and if table1 is fewer than table2 then do the copy.

_________________________
How to ask questions the smart way <-----------> Before you ask