Error Routines embedded in Programs within the DBMS

Private Sub Add_Member_Click()
.
.
.
STATEMENTS AND DIRECTIVES
.
.
. 
n Error GoTo Err_Add_Member_Click 
 
DoCmd.GoToRecord , , acNewRec 
Exit_Add_Member_Click:
Exit Sub 
Err_Add_Member_Click:
MsgBox Err.Description
Resume Exit_Add_Member_Click
End Sub

In general, sustained CPU utilization of over 70% means that something is wrong. Also, the queue of queries waiting for execution should be very short and virtually no commands should time out or run into a ‘deadlock’ - a term used to denote two commands that are simultaneously waiting for the other to exit before starting execution. Systematic monitoring and troubleshooting of a database - finding the causes of problems using performance indicators and solving problems as they arise - goes a long way towards making a database function smoothly.