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
"Mr. Smith" <nospam@[EMAIL PROTECTED]
> wrote in message
news:eIopHGnTJHA.5344@[EMAIL PROTECTED]
> 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
>>
>>
>>
>>
>
>
|
