Form loading slowly

H

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
 
J

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top