== Observation - Timing of this becoming a problem again ==
Pagasa observed that this became a problem again around the same time we changed the schedule of [[PHI Loader.accdb]]. We discussed possible connections but could not think of anything causal. Just putting this down here in case someone else can think of the connection. Ttenbergen 15:34, 2019 September 12 (CDT)
== Solution approach: Query size limiting ==
The error happens when trying to run [[Query send check centralized is owner]]. That query actually ties into the [[Centralized data.mdb]]'s L_Log. This makes for a very large record set, and have a max size of 1GB rather than the general Access limit of 2GB.
* 13:29, 2019 September 4 (CDT) - optimized the query further, seemed to eliminate error for now, but error has recurred since
== Solution approach: disconnecting wifi ==
Darryl from STB desktop had suggested that turning off wifi might fix this problem. Since they don't actually have wifi in their area this is easy to try. This worked during his tests, but they have had additional problems sending after that.
During additional tests at HSC Tina found out that sending is faster with wifi disabled, so she added some lines to the sending code that disconnect wifi at the start of sending.
== Solution approach: Maxlock setting ==
*https://access-programmers.co.uk/forums/showthread.php?t=285553 sugggests to apply the following
Noticed that we may not be getting Office updates installed ([https://support.microsoft.com/en-us/help/4501270/may-2019-updates-for-microsoft-office newest] not present)
==Status==
As of 09:48, 2019 September 4 (CDT) this is still a problem, and recently more of a problem.
Next things I will try:
* try to send from local to local - the query works fine when I run it while connected to a local version of CFE
* updating ccmdb.mdb to .accdb; if that is the solution we will also need to update many scripts and VBS/VBA programs.
== Related articles ==
{{Related Articles}}
* Is it possible to update to 2010 64bit before going accdb? https://stackoverflow.com/questions/34184018/does-upgrading-to-64-bit-access-fix-system-resource-exceeded-error
* Is it maybe related to the Windows 10 version build? Here's how to find the build: https://www.ilicomm.com/how-to-find-out-which-build-and-version-of-windows-10-you-have/
