Hi all,
I have just about finished my db, the back end sits on an nt4 server, the fe's on nt4 workstations, now when I test this at home, its perfect, even with 200k records in it, its pretty fast, but at work, its SLOW (even with only about 10000 records), the basic setup is that the user enters a customer postcode/house number and then it (the db) will bring up previous history on a subform, and allow entry of new info on the main form, which is then updated with a cmd button, but its very slow, it even takes like ages to open the db, I also noticed, that going from design view to form view, or vice versa, theres a lot of netwrok activity, I assume I went wrong somewhere?
TIA
CALV
I have just about finished my db, the back end sits on an nt4 server, the fe's on nt4 workstations, now when I test this at home, its perfect, even with 200k records in it, its pretty fast, but at work, its SLOW (even with only about 10000 records), the basic setup is that the user enters a customer postcode/house number and then it (the db) will bring up previous history on a subform, and allow entry of new info on the main form, which is then updated with a cmd button, but its very slow, it even takes like ages to open the db, I also noticed, that going from design view to form view, or vice versa, theres a lot of netwrok activity, I assume I went wrong somewhere?
TIA
CALV