"cannot open any more tables" in Access
Pagasa gets error "cannot open any more tables" in Access after doing a few things in CFE.
Short term fix is to exit and re-enter CFE.
No error, but cannot click any more
Error "cannot open any more tables" in Access
Steps to reproduce:
- open CFE
- open PatientList
- run PL 2Phin Fake or Blank via dropdown
- do ~24 times:
- click handshake
- open record with binocs
- do usual corrections
- close handshake form
At some repetition, as the binocs on the handshake form are clicked, error "cannot open any more tables" appears. At that point, e.g. trying to assign another pseudophin will give that error again. Error happens all over until the program is re-started.
Work-around: Do a compact repair, this will allow you to work again and is quicker than going out and back in.
- This is probably not specific to pseudocodes, that is just the only query to routinely result in that many re-openings
- The internet mentions this can happen when "set" statements aren't released, but I see no "set" statements as I step through this. Maybe the set statements happen from the handshake"
Error "Enter Parameter Value"
The parameter value error usually means a query is opened from somewhere I did not expect it to be opened from, e.g. opening a form expects that it will be opened for a specific record.
Other sites mention this can happen when recordsets are opened but not closed and set to nothing repeatedly. I would need to find out exactly what step this fails at for Pagasa to know where this needs to be addressed.
This is not related to a known bug in MS Access: https://support.microsoft.com/en-us/office/access-is-unable-to-close-and-leaves-lockfile-active-b2dce32b-b8b0-41f1-ba40-7876e524d9da As of 2022-11-16 we are using "Version 1808 (Build 10392.20029 Click-to-Run)" which is a version before the buggy one.
- 2022-06-16 - added several recordset .close statements to see if this will fix "cannot open any more tables" in Access