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

mNo edit summary
PTorres (talk | contribs)
No edit summary
Line 13: Line 13:
****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 always at a specific action or button press or similar where this happens? [[User:Ttenbergen|Ttenbergen]] 13:52, 2022 June 16 (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)
}}
}}


== 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]]