MS Office - Slow Network Access (Incl MS Access slow FE/BE)

  • Thread starter Thread starter Andre
  • Start date Start date
A

Andre

I noticed lately that access speed on a few Front End/Back End MS Access
Databases(V 2000) started getting very slow. These are split databases
where the BE file resides on a local share drive on our corporate network.

If I point my front end to a local PC copy of the backend database it runs
at full speed.

I have also noticed that when I save any office file (Access/Word/Excel),
typing the file name in the save as dialog box is slow. To explain it
better, it appears as if the keyboard has a delay when typing the file name.
I would complete typing the name, and the name would fill in letter by
letter. This does not happen when I save to my local drive.

I have un-installed and then re-installed MS Office, this did not correct
the problem

I also use some non-Microsoft apps and seem to have them same problems.

I guess it could be on of two things:
+ A common MS Office DLL or file has gone bad
+ I have some network issues that only affects Office.

Please advise how I can troubleshoot this.

Thank you,
Andre
 
Thanks for the response Cheryl.

I have reviewed and applied all the performance tips, including shutting
down my virus scan program etc. The problem still persists. The database is
a simple app with not much code or overhead and properly indexed tables etc.
For that matter, all my Access application are running slow. If a create a
simple access db with one table and one data field, same problems.

I am running a Dell laptop with 512 meg memory and Intel P4 processor (1.7
Mhz). The same Access application used to be lightning fast on this Laptop.

When i use any of our ancient desktops, typically with 128 meg memory and P3
800 Mhz processors, the application is lightning fast.

I was thinking initially that it could be a network issue, but have no idea
how to validate my access performance to the network. Any suggestions ?

What is strange, is that all my Office apps seem to have performance issues
when working on the shared drives...

I have also removed the NIC hardware/software and re-installed, updated the
drivers etc.

Thanks for any help
 
-----Original Message-----
Thanks for the response Cheryl.

I have reviewed and applied all the performance tips, including shutting
down my virus scan program etc. The problem still
Click to expand...
persists.

<snipped>

I'm just guessing but could you be running Find Fast?
This is an indexing tool that installs by default with
Office and gave me some performance problems such as you
describe (especially the keyboard hesitation) in the
distant past.

That leads me to another guess. See what's starting in
your Startup folder.

Roxie Aho
 
Roxie,
Thanks, I did not check Find Fast, I usually have it turned off, but
this may not be the case.

As for the startup group, I have shut everything down including my virus
software but this did not make a difference.

I will report back on my finding in the AM

Thanks again
Andre
 
FF was not even installed and i have now permanently disabled it, so this
was not the problem.

Thanks
 
Andre said:
Thanks for the response Cheryl.

I have reviewed and applied all the performance tips, including shutting
down my virus scan program etc. The problem still persists. The database is
a simple app with not much code or overhead and properly indexed tables etc.
For that matter, all my Access application are running slow. If a create a
simple access db with one table and one data field, same problems.
Click to expand...

#1 in Tony's list is to make sure you keep a connection open to the backend
database.

So, to be clear:

You have a font end installed on each pc, NOT on the server.
You are using a mde, and not a mdb. (and also track-name autocorrect is
off).
When your front end is run, it opens a connection to a table (any table)
in the back end, and keeps it open BEFORE the application does anything
else.


Are you sure you followed all the above tips from Tony's site? Obviously the
stuff like turning off sub-datasheets etc is also requited.

And, last by not least...are you sure Outlook journaling is turned off?
 
Back
Top