Report

[Pass-the-Reality]

I have two databases stored in the same folder on the same drive. The two
databases are NOT linked in any way (tables, queries, etc.....) 1 database
is for associate use and the other is for management only. I have a report
in the management database that associates will need to view daily. Can I
add a button to the switchboard of the associates database that will generate
the report from the management database? The report name is Monthly
Performance Report.

 

[Kipp Woodard]

The approach really depends on whether the Associates have the system
permissions to read the Management database file.

If they have read permission on the Management database file, then you can
create a query that references the Management database whithout actually
creating a linked table. I would create a query in the Management database
that would be used as the RowSource of the report. You would have to
replicate the Access Report object in both databases.

Here is an example of a query that references a query in another database
file:

SELECT qryReportData.*
FROM qryReportData IN 'C:\Documents and Settings\kwoodard\My
Documents\assets.accdb';

If the Associates do not have read permission on the Management database
file, then there are other approaches to be considered. One might be to
simply save the report, if it is not dynamic, as a PDF and get the Associates
a link to the PDF.