I'm trying to create a VBA archiving procedure that moves selected records from an "active" table in one database file to an "archive" table in a different database (the tables have the same structure). I want to do this from a 3rd database file, that essentially serves as a front-end. In the past, I've run append and delete queries using DoCmd.RunSQL but always within a single database. Any thoughts or guidance on methodology or SQL syntax to do this? Thanks, Paul