"cannot open any more tables" in Access: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
mNo edit summary
Line 1: Line 1:
{{Bug}}
{{Bug}}
Pagasa gets this error after doing a few things in [[CFE]].  
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.  
Short term fix is to exit and re-enter CFE.  


Longer term fix is for Tina to figure out why this even happens.
{{Discuss | who = Pagasa | question =
*After 24 rows, open and closed assigning Pseudo Phin an error message pop up then I cannot assign Phin anymore.  I closed CFE then open then I am good to go again.  The second time the error message pop up not 24 rows it less than 24 like 15 rows then it will show again the error message. [[User:PTorres|PTorres]] 16:09, 2022 June 14 (CDT)
** Is it the "cannot open..." error or the "enter parameter..." error you get at this point? [[User:Ttenbergen|Ttenbergen]] 10:49, 2022 November 16 (CST)
}}


== Error "cannot open any more tables" in Access ==
{{Discuss | who = Pagasa | question =
* After which action or button-press do you get the 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.


{{Discuss | who = Pagasa | question =
{{Discuss | who = Pagasa | question =
* If you figure out a pattern why this happens pls put it here. [[User:Ttenbergen|Ttenbergen]] 17:29, 2022 April 7 (CDT)
*Assigning Pseudo Phin or working on the queries if I worked long enough opened closed it then the error message pop up "Enter Parameter Value". PTorres 17:01, 2022 April 14 (CDT)  
**Assigning Pseudo Phin or working on the queries if I worked long enough opened closed it then the error message pop up "Enter Parameter Value". [[User:PTorres|PTorres]] 17:01, 2022 April 14 (CDT)
** What is the specific action or button press after which this happens? I.e. which step in [[Generating PseudoPHINs]]? [[User:Ttenbergen|Ttenbergen]] 10:49, 2022 November 16 (CST)
*** 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. Can you tell me what is the last thing you did before this error? [[User:Ttenbergen|Ttenbergen]] 10:58, 2022 April 21 (CDT)
****After 24 rows, open and closed assigning Pseudo Phin an error message pop up then I cannot assign Phin anymore. I closed CFE then open then I am good to go again.  The second time the error message pop up not 24 rows it less than 24 like 15 rows then it will show again the error message. [[User:PTorres|PTorres]] 16:09, 2022 June 14 (CDT)
***** Is it always at a specific action or button press or similar where this happens? [[User:Ttenbergen|Ttenbergen]] 13:52, 2022 June 16 (CDT)
* Yes. Tested it. [[User:PTorres|PTorres]] 13:55, 2022 June 16 (CDT)
}}
}}
== 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 ==
== Log ==
* 2022-06-16 - added several recordset .close statements to see if this will fix [["cannot open any more tables" in Access]]
* 2022-06-16 - added several recordset .close statements to see if this will fix [["cannot open any more tables" in Access]]

Revision as of 11:49, 2022 November 16

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.

  • After 24 rows, open and closed assigning Pseudo Phin an error message pop up then I cannot assign Phin anymore. I closed CFE then open then I am good to go again. The second time the error message pop up not 24 rows it less than 24 like 15 rows then it will show again the error message. PTorres 16:09, 2022 June 14 (CDT)
    • Is it the "cannot open..." error or the "enter parameter..." error you get at this point? Ttenbergen 10:49, 2022 November 16 (CST)
  • SMW


  • Cargo


  • Categories

Error "cannot open any more tables" in Access

  • After which action or button-press do you get the error "cannot open any more tables" in Access?
  • SMW


  • Cargo


  • Categories

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.

  • Assigning Pseudo Phin or working on the queries if I worked long enough opened closed it then the error message pop up "Enter Parameter Value". PTorres 17:01, 2022 April 14 (CDT)
  • SMW


  • Cargo


  • Categories

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