Slow performance Access 97 on Win NT 4.0

[i1055]

Has anyone else experienced slow performance running Access on NT 4.0?<br>
<br>
The processor is a PIII 550 and there is more than enough RAM (240 MB).<br>
<br>
All other applications run substanially faster but Access actually seems to be running slower now on this computer with NT 4.0 than it did on a less powerful computer running Windows 95.<br>
<br>
Any ideas on how to speed it up? Anyone else experience this?<br>
<br>
Thanks.

 

[DougP]

Well believe it or not Office '97 is tuned to run on NT<br>
<br>
There are several possibilities which come from the network side.<br>
Try this as a test <br>
Can you copy the Access database to that machines C:\ drive<br>
And see if it runs faster there. If so then it is Network related.<br>
Do you have Novell on the same Network ?<br>
<br>
<br>
<p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>

 

[JimHorton]

Can you elaborate on what, exactly is running slow? If the program itself (msaccess.exe) sits on the Server, you will always see generally slower response to everything, from opening the app to begin with, to opening forms, etc. <br>
<br>
Next, is the mdb on the Server? This will result in slower opening of forms, queries, reports, etc. If the mdb is on the server, you must be much more diligent about how you design queries and reports, especially with regard to indexes.<br>
<br>
If you are running a standalone version of access, with the mdb on the workstation, and you still get slow performance, let us know specifically what type of operations are slower.<br>
--Jim

 

[DougP]

He comparing an sceaming NT box which loads the same database slower than an old '9x box.<br>
<p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>