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

(2 intermediate revisions by the same user not shown)

Line 16:

== Error "cannot open any more tables" in Access ==

~~{{Discuss | who = Pagasa | question =~~

Steps to reproduce:

* After which action or ~~button-press~~ do ~~you get~~ the error "cannot open any more tables" in ~~Access?~~

# open CFE

* ~~When~~ I ~~am assigning Pseudo Phin~~ ~~I clicked ok then~~ the ~~error message shows up run time error 3014 cannot open any more~~ tables.

# open PatientList

* ~~Clicked end~~ and ~~close the CFE and log back in again.~~ [[~~User:PTorres|PTorres~~]] ~~14:54, 2022 November 30 (CST)~~

# run [[PL 2Phin Fake or Blank]] via dropdown

}}

# do ~24 times:

## click handshake

## open record with binocs

## do usual corrections

## close handshake form

At some repetition, as the binocs on the handshake form are clicked, error "cannot open any more tables" appears. At that point, e.g. trying to assign another pseudophin will give that error again. Error happens all over until the program is re-started.

Work-around: Do a compact repair, this will allow you to work again and is quicker than going out and back in.

Observations:

* This is probably not specific to pseudocodes, that is just the only query to routinely result in that many re-openings

* The internet mentions this can happen when "set" statements aren't released, but I see no "set" statements as I step through this. '''Maybe the set statements happen from the handshake"

{{Todo

| who = Tina

| todo_added = 2022-12-07

| todo_action = 2022-12-07

| question =

* Wasn't able to find what code tops out the tables, need to review further.

* When fixed, update [[PL 2Phin Fake or Blank]] and [[Generating PseudoPHINs]] to take out instructions about this bug }}

== Error "Enter Parameter Value" ==

Line 28:

Line 47:

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

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

** When I click the pseudo button to the left of the PHIN field label, nothing is moving.

*** When I click the pseudo button to the left of the PHIN field label, nothing is moving.[[User:PTorres|PTorres]] 15:23, 2022 November 30 (CST)

[[User:PTorres|PTorres]] 15:23, 2022 November 30 (CST)

**** I don't understand what you mean by that. What is the last thing you do before the "Enter Parameter Value" error happens? As in, what is the last button you click or last field you enter? [[User:Ttenbergen|Ttenbergen]] 12:15, 2022 December 7 (CST)

}}

@@ Line 16: / Line 16: @@
 == Error "cannot open any more tables" in Access ==
-{{Discuss | who = Pagasa | question =
+Steps to reproduce:
-* After which action or button-press do you get the error "cannot open any more tables" in Access?
+# open CFE
-* When I am assigning Pseudo Phin  I clicked ok then the error message shows up run time error 3014 cannot open any more tables.
+# open PatientList
-* Clicked end and close the CFE and log back in again. [[User:PTorres|PTorres]] 14:54, 2022 November 30 (CST)
+# run [[PL 2Phin Fake or Blank]] via dropdown
-}}
+# do ~24 times:
+## click handshake
+## open record with binocs
+## do usual corrections
+## close handshake form
+At some repetition, as the binocs on the handshake form are clicked, error "cannot open any more tables" appears. At that point, e.g. trying to assign another pseudophin will give that error again. Error happens all over until the program is re-started.
+Work-around: Do a compact repair, this will allow you to work again and is quicker than going out and back in.
+Observations:
+* This is probably not specific to pseudocodes, that is just the only query to routinely result in that many re-openings
+* The internet mentions this can happen when "set" statements aren't released, but I see no "set" statements as I step through this. '''Maybe the set statements happen from the handshake"
+{{Todo
+  | who = Tina
+ | todo_added = 2022-12-07
+ | todo_action = 2022-12-07
+ | question =
+* Wasn't able to find what code tops out the tables, need to review further.
+* When fixed, update [[PL 2Phin Fake or Blank]] and [[Generating PseudoPHINs]] to take out instructions about this bug }}
 == Error "Enter Parameter Value" ==
@@ Line 28: / Line 47: @@
 *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)
 ** 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)
-** When I click the pseudo button to the left of the PHIN field label, nothing is moving.
+*** When I click the pseudo button to the left of the PHIN field label, nothing is moving.[[User:PTorres|PTorres]] 15:23, 2022 November 30 (CST)
-[[User:PTorres|PTorres]] 15:23, 2022 November 30 (CST)
+**** I don't understand what you mean by that. What is the last thing you do before the "Enter Parameter Value" error happens? As in, what is the last button you click or last field you enter? [[User:Ttenbergen|Ttenbergen]] 12:15, 2022 December 7 (CST)
 }}