"cannot open any more tables" in Access: Difference between revisions
Line 12: | Line 12: | ||
**** Are you following the steps in [[Generating PseudoPHINs]] when this goes wrong? Which step in those instructions are you at when it stops responding and you need to restart the program? [[User:Ttenbergen|Ttenbergen]] 13:48, 2022 November 29 (CST) | **** Are you following the steps in [[Generating PseudoPHINs]] when this goes wrong? Which step in those instructions are you at when it stops responding and you need to restart the program? [[User:Ttenbergen|Ttenbergen]] 13:48, 2022 November 29 (CST) | ||
*** Yes, I am. I am clicking and assigning the new Pseudo Phin and not moving. | *** Yes, I am. I am clicking and assigning the new Pseudo Phin and not moving. [[User:PTorres|PTorres]] 14:47, 2022 November 30 (CST) | ||
}} | }} | ||
Revision as of 15:47, 2022 November 30
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
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.
|
Possible cause
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.
Dead ends
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.
Log
- 2022-06-16 - added several recordset .close statements to see if this will fix "cannot open any more tables" in Access