"cannot open any more tables" in Access: Difference between revisions
No edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
(One intermediate revision by the same user not shown) | |||
Line 1: | Line 1: | ||
{{Bug}} | {{Bug}} | ||
Pagasa gets | 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. | ||
{{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? Emailed Pagasa... [[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 = | ||
*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) | |||
** 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) | |||
** | |||
}} | }} | ||
== 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:50, 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.
|
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