Access Front End Bloating?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • NeoPa
    Recognized Expert Moderator MVP
    • Oct 2006
    • 32633

    #16
    Hi Twinny.

    Excellent. Your response amused me greatly and left me with a great big grin on my face.

    Helpful info :
    1. Did I ever tell you my user name came from my son who used to play online as Noe? I've taken a picture for after you do your retrospectives ;-)
    2. Relinking tables always creates a bit of extra space in the database. The space used for the tables as previously linked is not released when new space is assigned and used for the new versions. That's just how it is I'm afraid. Access was never designed to release space as this is background work and Access isn't really an RDBMS (Relational Database Management System). It's simply an RDB program. The former has background threads responsible for maintenance tasks whereas Access doesn't. To get a thread to run such maintenance tasks and remove any unused space in your database in Access you have to run it specifically. It is actually the C&R process.

    Comment

    • isladogs
      Recognized Expert Moderator Contributor
      • Jul 2007
      • 479

      #17
      @twinnyfo
      Did I read you correctly. You spooks have a fix for old age...
      Count me in... 😉

      Comment

      • twinnyfo
        Recognized Expert Moderator Specialist
        • Nov 2011
        • 3653

        #18
        IslaDogs,

        I did a poor job of properly delineating my antecedents. I fixed the spook-link. THAT has been fixed. That old age thing--we're still working on it.....


        ;-)

        Comment

        • isladogs
          Recognized Expert Moderator Contributor
          • Jul 2007
          • 479

          #19
          @twinnyfo
          LOL. Sorry but I couldn't resist....😎

          @NeoPa
          Great typo. Shall I start calling you NoePa instead?
          Last edited by isladogs; Mar 24 '21, 10:18 PM. Reason: Added a sentence

          Comment

          • SwissProgrammer
            New Member
            • Jun 2020
            • 220

            #20
            My mistake. I thought that you were re-re-compiling and having that issue compounded.

            After you explained that was wrong, I see that I was reading more into it than there was.

            Comment

            • NeoPa
              Recognized Expert Moderator MVP
              • Oct 2006
              • 32633

              #21
              What can I say? NoëPa maybe? To rhyme with Noël - but different. That would make life complicated for everyone :-D

              Comment

              • jcoogan
                New Member
                • Mar 2023
                • 1

                #22
                Here's another possibility that took me forever to discover. I am using Microsoft 365 subscription, ver 2302. Check menu: "File, Options, Current Database". Look for "Track name Autocorrect info" and uncheck it.

                I >think< the idea behind this option is that Access will auto correct other instances of objects behind the scenes when you change an object name. Example: You have two queries that are linked and you change the name of one, then Access will automagically update the name change in the separate join query, preventing it from breaking. Pretty cool, but also possibly pretty expensive in terms of database bloat because Access has to write all these object references somewhere!

                In my case I have a database with code only, data tables are in a separate linked database. The code database was bloating from 3000k to the 2gig limit in 20 min! My code database is doing a lot of database object and recordset object creation and deletion. When I unchecked the option named "Track name Autocorrect info" it resolved the issue and now the code database only grows by about 500k.

                Comment

                • NeoPa
                  Recognized Expert Moderator MVP
                  • Oct 2006
                  • 32633

                  #23
                  Indeed JCoogan.

                  Among the Access MVPs there are one or two who get very exercised about that little nugget. Most experienced developers recommend turning that off as soon as you can. Some suggest before making it on to solid food but others are more relaxed.

                  Comment

                  Working...