Copying reports from one database to another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We have 20 clients that are currently in a single
database. We prepare 4-5 reports for each client. We would
like to split the database per client, but we dont want to
change/create a report 20 times. What is an easy way to
duplicate these reports from one database to another?
 
We have 20 clients that are currently in a single
database. We prepare 4-5 reports for each client. We would
like to split the database per client, but we dont want to
change/create a report 20 times. What is an easy way to
duplicate these reports from one database to another?
Click to expand...

You can import any object from one database to another.
File + Get External Data + Import.
 
PLAN B:

Conversely, you can EXPORT most any object to another database.
Starting in the database that has all of the reports, choose the
REPORTS section and highlight a report. Click on FILE, EXPORT.
Navigate to the desired database. Click YES to overwrite, if
necessary.

Repeat for other reports and/or other destination databases.

NOTE: IF you are still using Access 97, be aware that A97 does not
like exporting objects when the object already exists in the target
database. After allowing you to export and overwrite one or two
objects, then it often crashes. This is not destructive, but IS an
annoyance.

If you are using Access 97, there is a very nice little freeware tool
that allows you to select multiple objects and export them without
error. Get it from the DEVELOPER TOOLS section here:

http://ourworld.compuserve.com/homepages/attac-cg/acgsoft.htm


PLAN C: Copy and rename the entire database using windows explorer,
then delete the data and reports that you no not need for that client.
 
You must also remember to export/import any underlying queries needed for
the reports.

Another option - copy the full database then delete the reports etc from
each of the databases that is not required
 
Back
Top