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
"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
>
>
>
>
|
