473,320 Members | 1,732 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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
Nov 12 '05 #1
2 4290

"Andante.in.Blue" <an***********@yahoo.ca> wrote in message
news:9d*************************@posting.google.co m...
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

Go to: http://www.mvps.org/access/
Best Regards
Bill "Bug Boy" Bennet, MVP
Nov 12 '05 #2
The main form is based on a query. By itself, the query runs rapidly,
without noticeable delay. The "problematic" 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
Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

12
by: Neil | last post by:
I previously posted re. this, but thought I'd try again with a summary of facts. I have an Access 2000 MDB with a SQL Server 7 back end. There is a view that is linked to the database via ODBC...
1
by: John Hunter | last post by:
I've recently had a nasty problem with the "Invalid reference to the property Form" error in subforms - nasty because it doesn't seem to consistently happen to all forms which contain the same...
4
by: microb0x | last post by:
I have an application with a master form with a tab control containing nine tabs, each tab contains a subform. I have command buttons on my main form including: Save , Cancel , Close. My...
3
by: CSharpguy | last post by:
I have 3 drop downs that are populated from the databasem 4 of my web pages need to have this drop down, how can I trap the selection made in the drop down and popuate my grid on my form?
0
by: Andy_Khosravi | last post by:
I'm having a problem trying to optimize the performance of one of my A97 databases. I have very slow record navigation after a change I made to the table structure, and I'm not sure how best to...
3
by: Michael | last post by:
I work with a highly programmed Access database (some 15,000 lines of VBA code, much of it automating data entry on forms -- and believe me, it's very tight code). In Access 97, 2000, 2002, and...
14
by: James | last post by:
I compile my code, I get a few errors, I go to the 1st error in the editor and start to type in the correct code and I get no where because with each key stroke the caret goes away, then a long...
0
by: jgrob3 | last post by:
I have a form which contains two subforms: and . The two subforms each have a SQL query to display their results in datasheet view and allow the user to tick which items have been billed. ...
4
by: Harlequin | last post by:
I have a question concerning the need to trigger events within a "child" subform which is itself enbedded within a master "parent" form and which is accessible via a tab in the parent form. Becuase...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.