Solved it.
Mr. Smith
"Mr. Smith" <nospam@[EMAIL PROTECTED]
> wrote in message
news:eaNATrmTJHA.5376@[EMAIL PROTECTED]
> 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
>
>
>
>
|
