Form loading slowly

[Hitesh Joshi]

Hi,
I am an MS Access newbie.
I have a form with two subforms. Main form and subform both quries the
SQL db though ODBC link. When I run main form and subforms
independently, they are very fast but as soon as I put them together in

a single form (main form + subforms), it takes 3-4 seconds to load.
There are not any complex calculation involved.
Is there anyway I make this load fast or atleast make it appear
faster.. like load main form and then have a button that can make
subforms visible?

Thank you,
hj

 

[John Vinson]

Hi,
I am an MS Access newbie.

and new to newsgroups as well, it appears. Your message was posted
four times. Not sure what software you're using to post - but once is
enough... we'll try to answer!

I have a form with two subforms. Main form and subform both quries the
SQL db though ODBC link. When I run main form and subforms
independently, they are very fast but as soon as I put them together in
a single form (main form + subforms), it takes 3-4 seconds to load.
There are not any complex calculation involved.
Is there anyway I make this load fast or atleast make it appear
faster.. like load main form and then have a button that can make
subforms visible?

Check Tony's Performace FAQ. I would guess that opening a persistant
connection to the SQL table might help...

http://www.granite.ab.ca/access/performancefaq.htm


John W. Vinson[MVP]