Maximum size of Access file or mdb

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

    Maximum size of Access file or mdb

    The file size of the Access application I'm currently working on is
    77,000 MB.
    What is the maximum size the Access file or MDB can be?

    Tags: None
    • Allen Browne
      #2
      Re: Maximum size of Access file or mdb

      Max file size is 2GB, so 77MB is nothing to worry about.

      77,000 MB might be a problem. :-)

      --
      Allen Browne - Microsoft MVP. Perth, Western Australia
      Tips for Access users - http://allenbrowne.com/tips.html
      Reply to group, rather than allenbrowne at mvps dot org.

      <tomlebold@msn. comwrote in message
      news:1175529589 .172272.246000@ y66g2000hsf.goo glegroups.com.. .
      The file size of the Access application I'm currently working on is
      77,000 MB.
      What is the maximum size the Access file or MDB can be?

        Comment

        • fredg
          #3
          Re: Maximum size of Access file or mdb

          On 2 Apr 2007 08:59:49 -0700, tomlebold@msn.c om wrote:
          The file size of the Access application I'm currently working on is
          77,000 MB.
          What is the maximum size the Access file or MDB can be?
          Look in Help
          Index tab + Specification + Access Specifications + Access Database
          --
          Fred
          Please respond only to this newsgroup.
          I do not reply to personal e-mail

            Comment

            • ManningFan
              #4
              Re: Maximum size of Access file or mdb

              On Apr 2, 12:04 pm, "Allen Browne" <AllenBro...@Se eSig.Invalidwro te:
              Max file size is 2GB, so 77MB is nothing to worry about.
              >
              77,000 MB might be a problem. :-)
              >
              --
              Allen Browne - Microsoft MVP. Perth, Western Australia
              Tips for Access users -http://allenbrowne.com/tips.html
              Reply to group, rather than allenbrowne at mvps dot org.
              >
              <tomleb...@msn. comwrote in message
              >
              news:1175529589 .172272.246000@ y66g2000hsf.goo glegroups.com.. .
              >
              >
              >
              The file size of the Access application I'm currently working on is
              77,000 MB.
              What is the maximum size the Access file or MDB can be?- Hide quoted text -
              >
              - Show quoted text -
              I thought A97 files could only reach 1GB? I seem to recall files
              blowing up on a regular basis at my old job if we didn't compact them
              twice a day once they hit 800MB, and I know we used A97 there.

                Comment

                • fredg
                  #5
                  Re: Maximum size of Access file or mdb

                  On 2 Apr 2007 11:15:11 -0700, ManningFan wrote:
                  On Apr 2, 12:04 pm, "Allen Browne" <AllenBro...@Se eSig.Invalidwro te:
                  >Max file size is 2GB, so 77MB is nothing to worry about.
                  >>
                  >77,000 MB might be a problem. :-)
                  >>
                  >--
                  >Allen Browne - Microsoft MVP. Perth, Western Australia
                  >Tips for Access users -http://allenbrowne.com/tips.html
                  >Reply to group, rather than allenbrowne at mvps dot org.
                  >>
                  ><tomleb...@msn .comwrote in message
                  >>
                  >news:117552958 9.172272.246000 @y66g2000hsf.go oglegroups.com. ..
                  >>
                  >>
                  >>
                  >>The file size of the Access application I'm currently working on is
                  >>77,000 MB.
                  >>What is the maximum size the Access file or MDB can be?- Hide quoted text -
                  >>
                  >- Show quoted text -
                  >
                  I thought A97 files could only reach 1GB? I seem to recall files
                  blowing up on a regular basis at my old job if we didn't compact them
                  twice a day once they hit 800MB, and I know we used A97 there.
                  You're correct. A97 does have a limit of 1 Gb. Unfortunately the OP
                  didn't tell us what his Access version is, and the majority of posts
                  are now for A2000 and newer.
                  --
                  Fred
                  Please respond only to this newsgroup.
                  I do not reply to personal e-mail

                    Comment

                    • David W. Fenton
                      #6
                      Re: Maximum size of Access file or mdb

                      fredg <fgutkind@examp le.invalidwrote in
                      news:2dw22vf6ca n9$.1pp74hblhts fk.dlg@40tude.n et:
                      You're correct. A97 does have a limit of 1 Gb. Unfortunately the
                      OP didn't tell us what his Access version is, and the majority of
                      posts are now for A2000 and newer.
                      You mean "Jet 4 and newer". It's not an Access limitation -- it's a
                      Jet database engine limitation.

                      --
                      David W. Fenton http://www.dfenton.com/
                      usenet at dfenton dot com http://www.dfenton.com/DFA/

                        Comment

                        • Scott
                          #7
                          Re: Maximum size of Access file or mdb

                          Have you tried to compact your DB?

                          <tomlebold@msn. comwrote in message
                          news:1175529589 .172272.246000@ y66g2000hsf.goo glegroups.com.. .
                          The file size of the Access application I'm currently working on is
                          77,000 MB.
                          What is the maximum size the Access file or MDB can be?
                          >

                            Comment

                            • Bob Alston
                              #8
                              Re: Maximum size of Access file or mdb

                              Scott wrote:
                              Have you tried to compact your DB?
                              >
                              <tomlebold@msn. comwrote in message
                              news:1175529589 .172272.246000@ y66g2000hsf.goo glegroups.com.. .
                              >The file size of the Access application I'm currently working on is
                              >77,000 MB.
                              >What is the maximum size the Access file or MDB can be?
                              >>
                              >
                              >
                              I have a client who got their MDB file up to about 2 gig. You don't
                              want to get that big if at all possible.

                              Their database was so big it could not run compress. I ended up
                              building an archive process, to create a separate MDB of historical data
                              and created a new, smaller db with current data. Their database is now
                              about 125 MB and working well.

                                Comment

                                Previous template Next
                                Working...