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
