DSM Labs Consistency check.accdb: Difference between revisions

Line 22: Line 22:
=== version 2020-05-06 ===
=== version 2020-05-06 ===
* added "DAO.DBEngine.SetOption dbmaxlocksperfile, 15000" to prevent out-of-diskspace error [http://www.accessrepairnrecovery.com/blog/fix-access-file-sharing-lock-count-exceeded-error]
* added "DAO.DBEngine.SetOption dbmaxlocksperfile, 15000" to prevent out-of-diskspace error [http://www.accessrepairnrecovery.com/blog/fix-access-file-sharing-lock-count-exceeded-error]
* changed query ''2_dedupe_appender_group'' to use a 0 rather than "not from group" for records arriving as test; this would have generated a hidden error all along but there would be no consequence to the data, this just cleans up that hidden error
* changed query ''2_dedupe_appender_group'' to set DSM_TestCode to 0 rather than "not from group" for records arriving as test; this would have generated a hidden error all along but there would be no consequence to the data, this just cleans up that hidden error


=== version 2019-12-18 ===
=== version 2019-12-18 ===