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

Line 1:

Pagasa gets ~~this~~ error after doing a few things in [[CFE]].

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.

~~Longer term fix is for Tina~~ to ~~figure out why~~ this ~~even happens.~~

{{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? [[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 =

* If you figure out a pattern why this happens pls put it here. [[User:Ttenbergen|Ttenbergen]] 17:29, 2022 April 7 (CDT)

*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)

**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". ~~[[User:~~PTorres~~|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)

*** 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. Can you tell me what is the last thing you did before~~ this ~~error~~? ~~[[User:Ttenbergen|Ttenbergen]] 10:58, 2022 April 21 (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)~~

* Yes. Tested it. [[User:~~PTorres|PTorres]] 13:55~~, 2022 ~~June~~ 16 (~~CDT~~)

}}

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

@@ Line 1: / Line 1: @@
 {{Bug}}
-Pagasa gets this error after doing a few things in [[CFE]].
+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.
-Longer term fix is for Tina to figure out why this even happens.
+{{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? [[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 =
-* If you figure out a pattern why this happens pls put it here. [[User:Ttenbergen|Ttenbergen]] 17:29, 2022 April 7 (CDT)
+*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)
-**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". [[User:PTorres|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)
-*** 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. Can you tell me what is the last thing you did before this error? [[User:Ttenbergen|Ttenbergen]] 10:58, 2022 April 21 (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)
-* Yes. Tested it. [[User:PTorres|PTorres]] 13:55, 2022 June 16 (CDT)
 }}
+== 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]]