"cannot open any more tables" in Access: Difference between revisions
Ttenbergen (talk | contribs) mNo edit summary |
|||
Line 7: | Line 7: | ||
{{Discuss | who = Pagasa | question = | {{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) | *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) | ** 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) | ||
*** | *** Still shows "cannot open "so I clicked ok then it says run time error 3014 cannot open any more tables. Closed the CFE then log back in. | ||
*** After I continue assigning Pseudo Phin after 25 rows "cannot open" showed up again I clicked ok then error message shows again. Closed CFE then log back in.[[User:PTorres|PTorres]] 14:42, 2022 November 30 (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) | **** 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) | ||
}} | }} |
Revision as of 15:42, 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