Run report in one database from another database

[Guest]

Is there a way to run a report that was built in one database from another
database? I have created a fairly complex report in one database that the
users of another database need to view, however, there is other functionality
in the database with the report that these users should not have access to.
I don't want to have to maintain the report in both databases if possible.
Thanks in advance for any suggestions.

 

[fredg]

Is there a way to run a report that was built in one database from another
database? I have created a fairly complex report in one database that the
users of another database need to view, however, there is other functionality
in the database with the report that these users should not have access to.
I don't want to have to maintain the report in both databases if possible.
Thanks in advance for any suggestions.

This works for me.

Create a new database.
Import (File + Import) just the one report (and any queries/modules
needed in the report) from the other database.
Link (File + Link) to just the table(s) in the other report that are
needed by the report.

After linking, right-click on the table name on the main folder.
Select Properties. Place a check in the Hidden attributes box.

Create a macro,
Action OpenReport ReportName

Name this macro
AutoExec

Save it
Save and close the new database.

On the database from which you wish to open the report, code a command
button:
Application.FollowHyperlink "Path to report database\DatabaseName.mdb"

When clicked, the new database report will appear. The user will not
see the table(s).