Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>You have closed the recordset and connection before you use it </p> <p><strong>rs closed here</strong></p> <pre><code> rs.Close </code></pre> <p><strong>and the connection is closed here</strong></p> <pre><code> cnn.Close Me.Liste_choix.RowSourceType = "Table/List" </code></pre> <p><strong>rs used here</strong></p> <pre><code>Me.Liste_choix.Recordset = rs </code></pre> <p><strong>Update</strong> From the <a href="http://msdn.microsoft.com/en-gb/library/windows/desktop/ms675814(v=vs.85).aspx" rel="nofollow noreferrer">docs</a>:</p> <blockquote> <p>Using the Close method to close a Connection object also closes any active Recordset objects associated with the connection. A Command object associated with the Connection object you are closing will persist, but it will no longer be associated with a Connection object; that is, its ActiveConnection property will be set to Nothing. Also, the Command object's Parameters collection will be cleared of any provider-defined parameters.</p> <p>Using the Close method to close a Recordset, Record, or Stream object releases the associated data and any exclusive access you may have had to the data through this particular object. You can later call the Open method to reopen the object with the same, or modified, attributes. While a Recordset object is closed, calling any methods that require a live cursor generates an error.</p> </blockquote> <p><strong>SQL INJECTION</strong> There is also an <a href="http://en.wikipedia.org/wiki/SQL_injection" rel="nofollow noreferrer">sql injection</a> risk by building sql directly from user input.<br> This question (<a href="https://stackoverflow.com/questions/6572448/msaccess-prepared-statements">MS Access prepared statements</a>) shows how to use a parametrised query - might be worth a look.</p>
    singulars
    1. This table or related slice is empty.
    1. POHow to populate a ListBox with a ADODB.Recordset (Error 91) To Do Autocompletion in Access
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USIan Kenney
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThis is not the reason of the error, when I move the rs.Close and cnn.Close under Me.Liste_choix.Recordset = rs, I already got the error.
      singulars
      1. PO
      1. USQuentin T.
    2. COdid you try move the rs.close / cnn.close to after you use the recordset?
      singulars
      1. PO
      1. USIan Kenney
    3. COYes... Me.Liste_choix.RowSourceType = "Table/List" Me.Liste_choix.Recordset = rs rs.Close cnn.Close
      singulars
      1. PO
      1. USQuentin T.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload