HI,
i am using msde 2000 sp3 and msaccess 2000 as front end. 5 LAN users.i have HUGE PROCEDURES in msaccess that checks for an new record in a table and if there is, then it does a lot of deletions, inserts and updations in other tables accordingly.DB size is 600mb, dual PIII 1.0 PROCESSORS, 160 scsi HD.

THE problem is that the process is carried on and is missed some times. Means sql does not slow or lock down and it skips some transections. WHY?after the process is completed it is supposed to deleted the processed record, so it deleted but sometimes the results are not accordingly.Confusinggg...