Code module size limits?

[Salad]

I'm asking this for curiosity's sake. Is there a code module size limit?

I looked at Access Specifications in help and didn't notice a code limit
size. For some odd reason I was under the assumption that code
modules couldn't exceed 64K...probably thinking of memos.

[lyle fairfield]

I've never had to worry about a size limit!

On Jun 23, 10:15*pm, Salad <[e-mail]:

I'm asking this for curiosity's sake. *Is there a code module size limit?

I looked at Access Specifications in help and didn't notice a code limit
* size. *For some odd reason I was under the assumption that code
modules couldn't exceed 64K...probably thinking of memos.

[Chris O'C via AccessMonster.com]

The limits for a Jet 4 db are:

Max 1,024 characters per line.
Max 6,601 lines per procedure.
Max 65,545 lines per module.
Max 1,000 modules per database.
Max 2 GB file size.

But don't go anywhere near those limits. If Access doesn't reach over and
smack you (by giving baffling error messages for no reason), one of your
fellow developers will.

Chris
Microsoft MVP
Salad wrote:

>I'm asking this for curiosity's sake. Is there a code module size limit?

I looked at Access Specifications in help and didn't notice a code limit
size. For some odd reason I was under the assumption that code
modules couldn't exceed 64K...probably thinking of memos.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200806/1

[Salad]

Chris O'C via AccessMonster.com wrote:

The limits for a Jet 4 db are:

Max 1,024 characters per line.
Max 6,601 lines per procedure.
Max 65,545 lines per module.
Max 1,000 modules per database.
Max 2 GB file size.

But don't go anywhere near those limits. If Access doesn't reach over and
smack you (by giving baffling error messages for no reason), one of your
fellow developers will.

There was a thread where somebody's memo field exceeded the memo size
limit. So I was curious about module sizes. I'd have to work to exceed
the limits you provided. Thanks for the info.

>
Chris
Microsoft MVP
Salad wrote:

>>I'm asking this for curiosity's sake. Is there a code module size limit?

I looked at Access Specifications in help and didn't notice a code limit
size. For some odd reason I was under the assumption that code
modules couldn't exceed 64K...probably thinking of memos.