Seems to be a popular subject! Anyway, moving along... I think I'm ready to start scripting. How do I go about adding new records and updating old records? Is the SQL the same for both? How does the SQL know to update an existing record rather than write a new one? Your DB1.MDB should make for a fine example.

Thanks!

-Jim