Slow on Novell & Win2000

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

les - 18 Nov 2003 21:24 GMT

Hello,

We run Access 97 application (Forms and Data together) on Novell 3.2 and 4.1
(and we tried on Win2000). This data is used by 50 people concurrently. If
the same data is run from the local PC it is very fast but is extremely slow
when it is run off any of the above Network Systems.

Should I change the network, database or file server? I was thinking about
the Linux 8.0 box for the file server and I wonder if anybody used it and
can share their opinions.

Any help is greatly appreciated,
Les

Reply to this Message

Cheryl Fischer - 18 Nov 2003 23:14 GMT

> Should I change the network, database or file server? I was thinking about
> the Linux 8.0 box for the file server and I wonder if anybody used it and
> can share their opinions.

Before you do any of those things, you may want to check some performance
tips here:

http://www.granite.ab.ca/access/performancefaq.htm

And, you really should consider splitting your application into a front-end
(everything but tables) and a back-end (tables only). Here is more info on
why and how to do it:

http://www.granite.ab.ca/access/splitapp.htm

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

> Hello,
>
[quoted text clipped - 9 lines]
> Any help is greatly appreciated,
> Les

Reply to this Message