Hi. I have several related database models which have many of the
same structures (tables/queries/reports). I usually develop or change
some of those structures within one database and then copy them to the
other. The problem is that when I copy and paste them, I can't select
multiple structures at once. Also, when I paste them, it would be
nice if I didn't have to type the name again (or copy and paste the
name separately). I know this is a little bit picky, but it really
does take a lot of time.

Does anyone have any idea how to do this?

On 23 Mar 2007 14:22:54 -0700, kramer31 wrote:

> Hi. I have several related database models which have many of the
> same structures (tables/queries/reports). I usually develop or change
> some of those structures within one database and then copy them to the
> other. The problem is that when I copy and paste them, I can't select
> multiple structures at once. Also, when I paste them, it would be
> nice if I didn't have to type the name again (or copy and paste the
> name separately). I know this is a little bit picky, but it really
> does take a lot of time.
>
> Does anyone have any idea how to do this?

Why not use:
File + Get External Data + Import ?
Navigate to the database you wish to copy.
Select all the objects you wish to import.
When you select the tables, click on Options and select
Definition only.
Click OK
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail