Forum Discussion
Updating recordset based on Access linked table runs too slow when entries are simultaneous.
Access front-end slows down when the time entry is made by at-least 3 simultaneous user/computer, the maximum number would be 6 computers at a time. Employees enter their time into a split Acc...
Matteo At least try using DateDiff:
Where EmplID='abc' And DateDiff('ww',Date(),[WorkDate])=0;