Thank you all for your responses so far. I have always wondered whether it's a connection issue with people working from home but it's then odd it only occurs on this one form and no others. I am not that tech savvy to move it to an SQL server but it might be worth looking into as we have speed issues also, so with moving it to SQL server would this also help with the database speed and performance?
CJ how do I get the form to check a required connection exists and Outlook is open before trying to run the transaction?
I have also had someone mention that moving the BE to Dataverse will help with a lot of the performance issues, anyone have a view on this?
Micron here is the code being called...
Code:
Public Sub UpdateQDPPaidJobsLog(strSAP As String, strPaidJobQDP As String)
strSQL = "INSERT INTO QDPChangeLog (SAP , ChangeDate , JobtoDeliveryQDP, User) VALUES ('" & strSAP & "' , NOW() , '" & strPaidJobQDP & "', fOSUsername() )"
'Debug.Print strSQL
CurrentDb.Execute strSQL, dbFailOnError + dbSeeChanges
End Sub
Code:
Public Sub UpdateQDPJobToDeliveryDateLog(strSAP As String, strJobtoDelivery As String)
strSQL = "INSERT INTO QDPChangeLog (SAP , ChangeDate , JobtoDeliveryDate, User) VALUES ('" & strSAP & "' , NOW() , '" & strJobtoDelivery & "', fOSUsername() )"
'Debug.Print strSQL
CurrentDb.Execute strSQL, dbFailOnError + dbSeeChanges
End Sub