Moduls Limitation

  • Thread starter Thread starter Oded Kovach
  • Start date Start date
O

Oded Kovach

Hello there

I have huge access application ON Access 97.

In the application i have reached to the limit of muduls i can add to access
file.

How can i add more moduls to my application and what is the exacly number of
moduls i can add to access?

any help would be useful
 
Take a look in the Help file under "specifications, Microsoft Access"

Under "database specifications", it states "Modules (including forms and
reports with the HasModule property set to True) 1024"
 
Thankes Douglas

The number of modules i use is quite closer to this

Now what can i do to comtinue adding new moduls to my program?

can you help me on it
 
Oded said:
Thankes Douglas

The number of modules i use is quite closer to this

Now what can i do to comtinue adding new moduls to my program?
Click to expand...

PMFJI, what do you use so many modules for?
 
Whell Bas

My application have aproxmently 687 forms and 400 reports. Many of them have
modules. This whay i've reached to this huge amount of moduls.

Now what i need to solve this and continue growing the application?
 
Oded,

Well, it seems like you have too many forms and reports! I wonder whether
you really need all of those... I suspect you could do with much less if you
parametrized some forms / reports to serve the purpose of several similar
ones in your current design. Any chance you have similar tables too?

Nikos
 
Oded said:
My application have aproxmently 687 forms and 400 reports. Many of them have
modules. This whay i've reached to this huge amount of moduls.
Click to expand...

That is remarkable. How can you manage so many forms at all? Can I see
the application somewhere? I'm really interested.

Maybe it is possible to remove the code from the forms, and put them in
common modules. You can set the HasModule property to false to be sure.
Functionality can be called from event properties set to a function
name--see Help about how exactly to do this.
 
PMFJI,

I can't imagine that all the users continually use all 687 forms and 400
reports. As Nicos says, it seems likely that you could dispose of some
of them by making more use of parameters.

But do all your users need all 687 forms and reports instantly
available? This application sounds as if it contains absolutely
everything. It would probably make sense to split this monster into
smaller applications, each containing a logical subset of the overall
functionality (order entry? stock management? accounts? human resources?
administration?) but all connected to the same back end.
 
Back
Top