Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.
The Execute statement takes about 20 seconds in the new file format while it only took 1-2 seconds with the old format. Anyway to remedy this?
CurrentDb.CreateQueryDef "qryNewlyCompleted", "SELECT x.ChequeNumber, x.ChequeDate, x.ChequeName FROM tblNSFs x, stblNSFs_original y WHERE x.ChequeNumber = y.ChequeNumber AND x.ChequeDate = y.ChequeDate AND x.ChequeName = y.ChequeName AND x.Completed = -1 AND y.Completed = 0" CurrentDb.Execute "UPDATE tblNSFs a SET [DateCompleted] = #" & DateValue(Format(Now(), "mm/dd/yyyy")) & "# WHERE EXISTS (SELECT 1 FROM qryNewlyCompleted b WHERE b.ChequeNumber = a.ChequeNumber AND b.ChequeDate = a.ChequeDate AND b.ChequeName = a.ChequeName)"
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
10 Experts available now in Live!