Transferring a query and a report 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
 
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
Click to expand...

Open the "To" database and then go to File - Get External Data - Import
 
Thanks for your quick response. But I'm not sure that would do the trick. I
don't want to transfer any data (external or otherwise). I want to transfer
the query and report definitions so that they can be used in the production
database. Do you have any recommendations as to how I can do that? Is there
a better approach to take than what I am trying to do?

Thanks again,
-- Tim Dempsey
 
OOOPs! I spoke too soon. Sorry! I goofed up when I tried your suggestion the
first time and thought it didn't work. I tried it again and found that it
worked like a charm. So, thank you very much for your help. It was very
timely.

Take care,
-- Tim Dempsey
 
Back
Top