By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,853 Members | 956 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,853 IT Pros & Developers. It's quick & easy.

Code module size limits?

P: n/a
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.
Jun 27 '08 #1
Share this Question
Share on Google+
3 Replies


P: n/a
I've never had to worry about a size limit!

On Jun 23, 10:15*pm, Salad <o...@vinegar.comwrote:
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.
Jun 27 '08 #2

P: n/a
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

Jun 27 '08 #3

P: n/a
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.

Jun 27 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.