Copying queries and reports from one Access database to another

  • Thread starter Thread starter tfdempsey
  • Start date Start date
T

tfdempsey

I am new to Access so I hope this isn't either too naive or asked about too
often.

I have inherited a functioning production-level database and I need to add
some queries and reports to it. I made a copy of the production database and
took the copy to another computer where I have developed the queries and
reports. Now that I am satisfied with what I have done, I'd like to move
those reports and queries over to the production database. They are both in
Access 2002. Can anyone advise me how to do this?

Thanks in advance....
-- Tim Dempsey
 
Open the database that is to "get" the new queries and reports. Click on
File | Get External Data | Import. Browse to the database that contains the
new queries and reports. Select that database. Then select the desired
queries and reports from the window that appears (shows all objects in the
second database). Click Import (or OK, I forget what it's called).

The queries and reports are imported into your original database.
 
Back
Top