Slow in saving record in network, multi-user platform.

[Amika]

I have a backend database in network about 350MB (compacted).
Recently I found that when about 8 users try to alter different
records in same table (table size is about 100,000 records), a time
lag (about 10-20 sec or more) will be happened in saving record.

Does anyone know what's the problem and how to fix it? Is it better
to use MSSQL in backend?

My platform:
backend mdb file (data only) in network (Win 2000 server)
frontend mdb file (programme and logic) in each client computer (Win
XP SP2)
LAN 100Mb
No other services in the network.
I am using Access 2003

Many thanks!!

 

[Amika]

I just try to use row locking rather than no locking, subdatasheets
and track name actocorrect info have already off. Defrag the harddisk
and the HDD does have space.

Time lag still occur but i feel that the lag time is shorter. Now lag
time last for about 5-10sec.

any other thing I can do?