We have this Contact Management application running in our office (captures sales, product details sold, quotations, orders, customer analyses, inventory onhand etc etc...)
It runs on an NT Server 10 users (specs are 64MB, UDMA-8GB HDD, Pentium 266 CPU, 100Mbs hub/cables). The front end on all our Win 95 & 98 clients is a 19-MB sized MDE file (with about 85 forms, 300 queries and tons of module-codes) and links to the server which contains a 45MB MDB database (just tables only - about 50 of them).
The system now crawls when only 3 users are logging on. Is there anything I can do to improve performance? Or is this method of setting up wrong? Any better suggestions so we can contine using the existing setup?
Thanks a million!