Re: mydb.close

From: Sharrukin Amiri (sharrukin_at_amtekcenter.com)
Date: 05/18/04

  • Next message: david epsom dot com dot au: "Re: Using DAO with Access2003 database" 
    Date: Tue, 18 May 2004 16:36:14 -0400

    Thanks David...

    "david epsom dot com dot au" <david@epsomdotcomdotau> wrote in message
    news:40a88656$0$2300$61ce578d@news.syd.swiftdsl.com.au...
    > You can keep querying the database as long as your
    > database variable is true and valid.
    >
    > A97 Database connections do not time out.
    >
    > If you use the close method of a database object,
    > that will close the connection.
    >
    > Or, if you do not use the close method, the DAO
    > database engine will maintain a count of open
    > references to the file, and will close the file
    > when the reference count drops to zero.
    >
    > Open recordsets also maintain a reference to the file.
    >
    > Reference counts are decremented when you Close a
    > Recordset, or it goes out of scope, or you set the
    > recordset variable to 'nothing', or when you
    > set a database variable to 'nothing' or when it
    > goes out of scope.
    >
    > If you have more than one connection, and you close
    > one connection, the file will remain open, and the
    > other connection will remain valid, but the connection
    > you closed will be gone.
    >
    >
    > "Sharrukin Amiri" <sharrukin@amtekcenter.com> wrote in message
    > news:_pSoc.31062$dr1.814154@news20.bellglobal.com...
    > > Hello,
    > >
    > > When I open a connection to a local MS Access 97 Database using DAO,
    would
    > I
    > > need to close the connection after doing what ever I need to do with the
    > > records within a table. If I do not close the connection, can I keep
    > > querying the database. Is there a timeout on the opened connection?
    > >
    > > Thanks!
    > >
    > > Sharrukin
    > > sharrukin@amtekcenter.com
    > >
    > >
    >
    >

  • Next message: david epsom dot com dot au: "Re: Using DAO with Access2003 database"

    Relevant Pages

    • Re: Connection types and speeds
      ... The memory used by holding the connection open is not ... All recordset inserts seen to consequently have 0ms execution time, ... actually written to the database while the code has regained control ... RecordsetClone of a form) when a transaction was rolled back, ...
      (microsoft.public.access.queries)
    • Re: database project
      ... data connection was created and i entered credentials. ... i am prompted for credentials. ... Another DB reference is (Database References) in DataBase Project. ...
      (microsoft.public.vsnet.ide)
    • Re: VBA - "Out of stack space" error
      ... written for AutoCAD VBA generates an 'Out of stack space' ... I create the ADODB connection... ... > ' If the connection to the database has been opened ... where I try to open the recordset. ...
      (microsoft.public.vb.database.ado)
    • Re: adodb
      ... without knowing how the database is implemented. ... required to access a database when using ADO, although one can use ADO to ... A Connection object represents a unique session with a data source. ... A Recordset object represents the entire set of records from a base table ...
      (microsoft.public.vb.database.ado)
    • Re: adodb
      ... > without knowing how the database is implemented. ... > required to access a database when using ADO, although one can use ADO to ... > A Connection object represents a unique session with a data source. ... At any time, the Recordset object ...
      (microsoft.public.vb.database.ado)
    Loading