Can Access reports be in another MDB

[DanJ]

We have a very large Access database that uses SQL Server as the backend
datasource. Many of the reports in the database apply to all users and
therefore are part of our 'core' .MDB. We are often asked to add new reports
which are 'custom' reports which apply to only certain customers. We do not
want to add these custom reports to the core, but would like to have them in
another .MDB. We would then like to access them from the core .MDB when
needed. Is this possible? Many of the reports reference forms in the core
database for information such as date ranges and other ID information. I am
looking for a way to create a 'report' repository that stores all reports. I
would then selectively make them available to the appropriate customers. Has
anyone done this or can someone point me in the right direction?

 

[Jeff Boyce]

Dan

Another approach, rather than scattering report definitions around and
having to keep linked to them all would be to keep all report definitions in
one place, keep a table of "available" reports in the back-end, and somehow
identify which reports in that table "belong" to which user(s).

That way, you could create a Reports Order form that limits the "available"
reports displayed to those the (logged on) user is authorized to see.

You could still see all the reports available, but since your users were
working via forms, they'd never see all reports.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[DanJ]

We already are storing the reports in a table which does exactly what you
described. Our problem is that the Access 'core' database is getting too
large and we are running into 'out of memory' and 'corruption' issues. We
have already split some things out of the database to reduce it's size and
make it more stable. However, our customers are State agencies who all have
their own State reports which will add 100s of new reports which I don't want
to add to the core. I'd like to have a reports repository where I can
separate custom reports by State. I'm even willing to consider doing
something in VB6 if necessary to get these reports out of the core .MDB.

 

[R. Wilson]

I use hyperlinks to call reports from other MDBs.