Form loading takes forever after migration

[Mr. Smith]

Hi.

Have an Access application with linked tables to a SQL server. Just relinked
the application from a SQL 7.0 environment to a SQL 2005 environment. All
linked tables are accessible and looks "all right". Problem is that the main
form loads really, really, really slow. Took about 5 seconds before, but
takes like 6 minutes now.



The main form is heavy loaded with subforms and VBA database communication
etc. Thought it might be due to that, but I put an msgbox "Start Load",
vbOkonly in the first line of the Form_load sub. And it showed after about 6
minutes......



By that I recon the problem is before the load event of the main form. What
the heck happens before load?



Hope some of you would help me with an approace.



Kind regards

Mr. Smith

 

[Mr. Smith]

Solved it.

Mr. Smith

 

[Jeff Boyce]

A couple possibilities suggest themselves...

Is there a chance that the network over which the Access front-end links to
the SQL-Server has been recently "upgraded" to include antivirus protection
(or an updated antivirus table loaded)? My installations suffered a similar
slow-down after an "upgrade".

Is there a chance that your form is loading ALL the records before
displaying? That is, is the form bound to a single record, or to the entire
table?

Also, there might be an issue with having/holding a connection open rather
than re-connecting each time.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jeff Boyce]

Other people may run into a situation similar to yours. How you solved it
may help them with their situation.

Please post back how you solved it...

Regards

Jeff Boyce
Microsoft Office/Access MVP