I am running a data base that as I update a field of no good part numbers it retrieves the production quantity and then calculates a percentage. This opperation currently takes way too long to complete. The vba code is shown below. Very simple code. It also seems that the entire database runs slow just opening forms and other simple processes sometime. Any ideas what to do. Or is access just no able to handle this amount of data. It is wierd sometimes it seems the entire database runs completely fine but this is rare.
Private Sub PorosityQty_Change()
Me.RetriveProdData
Me.PercentCal
End Sub
Private Sub PorosityQty_Exit(Cancel As Integer)
Me.RetriveProdData
Me.PercentCal
End Sub