Time to move on...

[PeterM]

This is fascinating...

If I understand you correctly...I can take my existing .mdb (80meg) and
break it into smaller .mdb's and then create a master .mdb that calls the
forms in one of the smaller .mdb's.

In order to do this, I need to add a reference to all of the smaller .mdb's
in the master .mdb (Tools >>> References). do I have it correct?

Is there some documentation or an example that you know of I could see?

Thanks David!

 

[david epsom dot com dot au]

You can't directly call a form (it was never easy, and
the feature was disabled in A2003). Instead, you need
to have a function in each module to open forms and
run reports. And nothing appears in the database window
of the shell - you need to add items to a custom menu
to call your application entry points.

In order to do this, I need to add a reference to all of the
smaller .mdb's in the master .mdb (Tools >>> References).
do I have it correct?
Yes.

Is there some documentation or an example that you know of I could see?

Not that I can think of. Access version 2.0 was built like
this, so you could see all of the wizards and utilities as
examples, and even in A97 some of the wizards and utilities
were built sort of like this, but not any more.

BTW, when you have all your mdb's loaded, you can also call
down and sideways from one to another, using Run or Eval.
Code can call up directly.

DLookup and TransferText only refer to tables in the shell
mdb.

Code references to CurrentDB will have to be change to CodeDB.

(david)

 

[david epsom dot com dot au]

And, FWIW, we use a bound control for the Report
Logo. The actual bitmap is stored in the database,
and clients use their own bitmaps. We have hundreds
of reports, but normally just two copies of the
bitmap: a report header bitmap, and a report footer
bitmap. Every report that uses the bitmaps links
to the bitmap table. In most cases, I didn't
write the query, and there is a 'cartiesion
join': there is only one record in the bitmap
table, and the table is just included in the
report source.

(david)

 

[PeterM]

So the shell would simply have a custom menu calling forms in the application
modules?

What is contained in the Application modules? forms? queries? reports?
tables? modules? macros?

What is contained in the Library module? forms? queries? reports? tables?
modules? macros?

 

[pquintana]

I've removed all graphics from the forms and reports which dropped it down
about 5 meg only.

Is there a way in Access to see if a query, form, report, macro and module
are referenced in the app? If I could determine the dead items, I could
reduce the size by deleting them?

Don't think I'm doing anything strange..........

 

[Guest]

So the shell would simply have a custom menu calling forms in the application
modules?

Yes, although we actually have an autokeys and an autoexec macro,
and a macro to check references, and the re-linking form, and the
"keep links open" form and some other stuff.

What is contained in the Application modules? forms? queries? reports?
tables? modules? macros?

Yes, but the only macro's are for debug/development. I don't
know if there is an easy way to call macro's in a reference. And
you need modules, to contain the entry points for the forms and
reports.

What is contained in the Library module? forms? queries? reports? tables?
modules? macros?

Yes. I've gotten all of the reports out, that was easy because all report
calls are table driven through the report manager, but I've still got forms
for all the reference data. I want to move the forms out as well, but
because the application modules have direct calls to the entry points, the
calls from the application modules will have to change, so it is a political
decision.

(david)

 

[Larry Linson]

Another "offender" for bloating DB size is the textures that the Wizard
"lures you into using" on Forms. When I put examples on the net, I generally
go in and remove the "background picture" and just choose a pleasing soft
color... and it does decrease the size -- a courtesy to those who download
my examples.

Larry Linson
Microsoft Access MVP