copying query and report to another database

[Caroline]

I created a database for a business that has been using
it for a year. They called and wanted a new report
created. I created it using an old copy of the database
that I had but the data is obviously not current.
How can I copy the report and associated query over to
the current database? I am planning on just going there
and creating it in the active database if I don't get
another option.

 

[GVaught]

This also would be an excellent time to split their database into two
sections: Backend with only the table data and a frontend with linked
tables, queries, reports, etc. This way when you make an update to the
frontend you don't have to worry about the data. You can make changes to the
frontend to your hearts content.

The only thing you would have to do from the point of splitting is take a
current copy of the frontend to make sure you have the most current copy.
Then if they request a new report or form you can create it and just send
them the new frontend; this is assuming they never add anything to the
database themselves. You never touch their data files.

The only time you would have to touch the backend is if you have to create a
new field for them and you would do that on site at the time you deliver
their new frontend.

 

[david epsom dot com dot au]

Also, if you can open both MDB at the same time,
'Copy & Paste' will work.

(david)