Bobby Heid
bheid at appdevgrp.com
Fri Sep 17 06:56:03 CDT 2004
Could you not use a make-table query? Something like: SELECT sometable1.* INTO sometable2 IN 'D:\Data\DB3.mdb' FROM sometable1; Bobby -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Barbara Ryan Sent: Thursday, September 16, 2004 5:53 PM To: Access List Subject: [AccessD] Copy tables from/to databases other than the Current db Using code in an Access 97 application (let's call it DB1), I need to copy tables from database DB2 to database DB3. I know how to copy objects from DB1 to DB3 (using Transferdatabase), but this is stumping me. More info --- DB1 is the front end of the application; DB2 is the back end (tables) of the application, and DB3 is a temporary database that I create "on the fly" (using code in the front end). I can't copy the tables from DB1 to DB3 because DB1 only contains the links to tables in DB2. Hope this isn't too confusing! Thanks, Barb Ryan -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com