Code module size limits?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Salad
    #1

    Code module size limits?

    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.
    Tags: None
    • lyle fairfield
      #2
      Re: Code module size limits?

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

      On Jun 23, 10:15 pm, Salad <o...@vinegar.c omwrote:
      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.

        Comment

        • Chris O'C via AccessMonster.com
          #3
          Re: Code module size limits?

          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.c om
          http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200806/1


            Comment

            • Salad
              #4
              Re: Code module size limits?

              Chris O'C via AccessMonster.c om 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.
              >
              >

                Comment

                Previous template Next
                Working...