"cannot open any more tables" in Access: Difference between revisions
Line 18: | Line 18: | ||
{{Discuss | who = Pagasa | question = | {{Discuss | who = Pagasa | question = | ||
* After which action or button-press do you get the 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? | ||
* I clicked ok then the error message shows up run time error 3014 cannot open any more tables. | * When I am assigning Pseudo Phin I clicked ok then the error message shows up run time error 3014 cannot open any more tables. | ||
* Clicked end and close the CFE and log back in again. [[User:PTorres|PTorres]] 14:54, 2022 November 30 (CST) | * Clicked end and close the CFE and log back in again. [[User:PTorres|PTorres]] 14:54, 2022 November 30 (CST) | ||
}} | }} |
Revision as of 15:20, 30 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.
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