can't add modules to the application

  • Thread starter Thread starter meimad
  • Start date Start date
M

meimad

When I try to add a form or a report to an application I
can do it, but when I want to add some code to it - I
receive an error message : Failed to create the Visual
Basic Module
Also, when I try to add an independent module to the
application - I receive message: Out of Memory
The only thing I can do in order to add a new module is
to erase an existing module of form or report that has
module. It seems like I've riched the limit of number of
modules that I can create. Can it be? Or it's some bug
that has a solution?
I'm working with Access2000 and I have around 630 forms,
280 reports and 10 global modules. The size of mdb is
around 45MB. I also tryed to compile, decompile, compact
and even export to a new application - nothing helps.

Sorry it's so long.
I hope somebody can help me with this.
 
I'm working with Access2000 and I have around 630 forms,
280 reports and 10 global modules. The size of mdb is
around 45MB. I also tryed to compile, decompile, compact
and even export to a new application - nothing helps.
Click to expand...

According to Access specifications:
Modules (including forms and reports with the HasModule property set to
True) 1,000

Looking at the number of forms and reports, you are still under the limit,
although barely. One thing you can do is to loop through the forms/reports
and if they don't have code behind them, set the 'HasModule' property to
False. Otherwise look into splitting the database code into Access Addins.

-- Dev
 
Please tell me more about splitting the database code
into Access Addins. I'm not familiar with this subject.
Maybe you can give me a link to some article which
explains how can I do this.

I'll be very gratefull for any help.
Thanks again
 
Back
Top