Slow Downs between Form and Subforms

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

    Slow Downs between Form and Subforms

    Hello, I have just inherited a very undocumented legacy database,
    developed in and still running on Access 97. The file is an MDB file,
    with no security. It is placed in a shared directory on a dedicated
    server, but it is usually accessed only by 1 user; the development
    copy I use is not accessed by anyone else).

    I am going through the database and fixing logic errors and attempting
    to optimize the efficiency of the code. I am finding that one of my
    forms is taking an awefully long time when loading in View Mode
    (almost 30 seconds). I have traced the code and a major delay seems
    to be happening between the loading of a subform and the main form.

    To be more precise, I have 2 subforms on the first page of the main
    form. I placed MsgBox statements in each of their Load and Open
    events. Strangely enough, a significant pause occurs between
    Subform2_Load and Form_Open. Does anyone know what could be happening
    here? A Break-and-Step-Through reveals no VBA code being executed
    between the events. The table records (as I understand it) are
    accessed between the Open and Load events of a form... so I have no
    idea what could be tying up the processor.

    Any suggestions or comments would be immensely welcome! Thank you in
    advance!

    Alan
    Tags: None
    • BugBoy
      #2
      Re: Slow Downs between Form and Subforms


      "Andante.in.Blu e" <andanteinblue@ yahoo.ca> wrote in message
      news:9dd2da98.0 309081042.8aa79 99@posting.goog le.com...[color=blue]
      > Hello, I have just inherited a very undocumented legacy database,
      > developed in and still running on Access 97. The file is an MDB file,
      > with no security. It is placed in a shared directory on a dedicated
      > server, but it is usually accessed only by 1 user; the development
      > copy I use is not accessed by anyone else).
      >
      > I am going through the database and fixing logic errors and attempting
      > to optimize the efficiency of the code. I am finding that one of my
      > forms is taking an awefully long time when loading in View Mode
      > (almost 30 seconds). I have traced the code and a major delay seems
      > to be happening between the loading of a subform and the main form.
      >
      > To be more precise, I have 2 subforms on the first page of the main
      > form. I placed MsgBox statements in each of their Load and Open
      > events. Strangely enough, a significant pause occurs between
      > Subform2_Load and Form_Open. Does anyone know what could be happening
      > here? A Break-and-Step-Through reveals no VBA code being executed
      > between the events. The table records (as I understand it) are
      > accessed between the Open and Load events of a form... so I have no
      > idea what could be tying up the processor.
      >
      > Any suggestions or comments would be immensely welcome! Thank you in
      > advance!
      >
      > Alan[/color]


      Go to: http://www.mvps.org/access/
      Best Regards
      Bill "Bug Boy" Bennet, MVP


        Comment

        • Andante.in.Blue
          #3
          Re: Slow Downs between Form and Subforms

          The main form is based on a query. By itself, the query runs rapidly,
          without noticeable delay. The "problemati c" subform (the one whose
          Load event is called immediately before the delay strikes) retrives
          information from a table (which also loads fine) based on a simple
          pair of link fields.

          All the data from the tables are stored within the MDB itself. There
          seems to be a linked table to an external data source, but the table
          is not utilized on any of the main forms.

          The database is a single shared file, not a front-end / back-end
          database. I believe this decision was made either because the my
          predecessor does not know about FE/BE constructs, or because the
          database will rarely be opened by more than 1 person at a time. I
          hope the latter was the case, but I suspect the former is true.

          The main form itself is fairly heavily populated though. It contains
          several other subforms that are either linked by simple fields, or
          otherwise pull from queries using a filter set elsewhere on the form.

          Several other subforms are present but seperated on another page in a
          Tab Control. Does this mean the processes for the other subforms is
          not loaded until the appropriate page is activated? Or does Access
          "do something" for the other subforms when loading the main one? My
          guess is the former, since there is another very noticeable delay when
          I switch to a particular page in the tab control. If somehow
          seperating these tab pages into their own forms will help with speed,
          though, I would gladly do it.

          Thanks,

          Alan

            Comment

            Previous template Next
            Working...