max size of a module/sub

[jiml]

Seems to be a 64k limit to module (or subroutine) size in
Access2000. I get a compilation error when I try to
convert the .mdb its in. Access Help implies that it will
run, but slower. But when user tries to run it, they get
same compilation error.

Is there a way to turn off compilation?

Jim L

 

[Douglas J. Steele]

Since running a module involves being able to compile it, turning off
compilation won't buy you anything.

I can't for the life of me imagine a module that's 64K! You need to look at
breaking it down into smaller components.