Re: Form loading takes forever after migration

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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@xxxxxxxxxx> wrote in message
news:eaNATrmTJHA.5376@xxxxxxxxxxxxxxxxxxxxxxx
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






.

Relevant Pages

  • Re: Sql ce server process
    ... We are certainly aware of the dll load issue, ... application that is using sqlmobile and is on the virge of disaster. ... running 2 processes at the same time, one that uses the SQL Mobile engine ... unmanaged SQL Compact DLLs is that you need to get them loaded early in the ...
    (microsoft.public.sqlserver.ce)
  • Re: Sql ce server process
    ... We are unlikely to target another platform until WM7 ... My plan is not to try to use sql in any more robust of a fassion than was ... load on the database that is any more heavy than the load that exists today, ...
    (microsoft.public.sqlserver.ce)
  • Re: load access table to sql
    ... I'm able to load the table now using very similar code. ... having is because of a column named "Group" in both the local and sql table. ... >> Dim rst As Recordset ...
    (microsoft.public.access.modulesdaovba)
  • Re: Create index, create table statements are locking each other
    ... with same partition logic without indexes first, ... sql 2008 enterprise. ... SSIS packages do asynchronous data loads and after ... the data load create indexes for the finished data loads to speed up the ...
    (microsoft.public.sqlserver.programming)
  • Re: Specific LIKE statement
    ... But I need to load all records where field Name is one of the names in this string: "John is director, Jack is programmer, Jim is Analyst, James is manager". ... How to do that with SQL? ...
    (microsoft.public.dotnet.framework.aspnet)