Create mutiple tables in remote DB stickandrock 29.09.2006 18:53:02 I have a db (a) that has about 50 linked tables. About 20 of the tables I would like to create make tables of these 20 into another db(b). Is there a way to do this without creating 20 make-table quiries and then running them through 1 macro. Thanks

Re: Create mutiple tables in remote DB "Jeff Boyce" <nonsense[ at ]nonsense.com> 29.09.2006 19:20:24 It would be a very unusual situation that required creating "20 make-table queries". Can you describe a bit more about what you are trying to accomplish (you've described HOW you are trying to do something, but not WHAT that something is...)? Regards Jeff Boyce Microsoft Office/Access MVP "stickandrock" <stickandrock[ at ]discussions.microsoft.com> wrote in message news:5B468B82-1705-4AA1-B31C-26BCCB946CFD[ at ]microsoft.com... [Quoted Text] >I have a db (a) that has about 50 linked tables. About 20 of the tables I > would like to create make tables of these 20 into another db(b). > > Is there a way to do this without creating 20 make-table quiries and then > running them through 1 macro. > > Thanks