Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
strSQL = "DELETE FROM SummaryReport" CurrentDb.Execute strSQL strSQL = "INSERT INTO SummaryReport ( Clients, [Entered Invoices], [EMS Line Item], [No Of Errors] ) " _ & "SELECT ClientName.ClientName AS Clients, Count(QCLog.Noli) AS [Entered Invoices], " _ & "Sum(QCLog.Noli) AS [EMS Line Item], Sum(QCLog.NumofErr) as [No of Errors] " _ & "FROM ClientName LEFT JOIN QCLog ON ClientName.ClientName = QCLog.ClientName " _ & " WHERE (([QCLog].[CheckedDate]) >= # " & st1 & " #) AND (([QCLog].[CheckedDate]) <= # " & st2 & " #) GROUP BY ClientName.ClientName;" CurrentDb.Execute strSQL On Error GoTo errorhandler DoCmd.SetWarnings False DoCmd.OutputTo acOutputTable, "SummaryReport", acFormatXLS
|DBF to ... Converter||5||38|
|Backup and restore code in split Access 2016 Database using switchboard||2||17|
|Azure SQL Insert not working suddenly||11||21|
|Continuous form : Prefilled Data||7||10|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
16 Experts available now in Live!