"cannot open any more tables" in Access: Difference between revisions
Ttenbergen (talk | contribs) mNo edit summary |
No edit summary |
||
| Line 6: | Line 6: | ||
{{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) Not showing any error but cannot click anymore so I go out and log back in. [[User:PTorres|PTorres]] 16:56, 2022 November 23 (CST) | ||
}} | }} | ||
== Error "cannot open any more tables" in Access == | == Error "cannot open any more tables" in Access == | ||
Revision as of 16:56, 23 November 2022
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