Disconnected recordset?


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: Disconnected recordset?

  1. #1
    Join Date
    Jun 2006
    Posts
    168

    Disconnected recordset?

    Hi,

    I'm using Vb6 to create a sql query and return a recordset from access.


    How can I disconnect this recordset to be able to use it without needing the connection to the db?

    every time i've tried to do it, it erases the data in it. but I know i'm not doing it right.



    also, as a side benefit, if i can disconnect my recordsets, would that speed up my application any?
    -Jon


    Visual Basic 6.0
    Microsoft Access 2003

  2. #2
    Join Date
    Dec 2003
    Posts
    2,750
    Are you setting the ActiveConnection property of the Recordset to Nothing? Are you using a client-side cursor?
    Paul
    ~~~~
    Microsoft MVP (Visual Basic)

  3. #3
    Join Date
    Jun 2006
    Posts
    168
    Quote Originally Posted by pclement
    Are you setting the ActiveConnection property of the Recordset to Nothing? Are you using a client-side cursor?
    no, i was just closing the connection.

    I think i just figured that out, setting the activeconnection property to nothing. I believe it's working now.

    Thanks

    seems like it's usually (very) easy to figure things out, right after i post about them. haha
    -Jon


    Visual Basic 6.0
    Microsoft Access 2003

  4. #4
    Join Date
    Oct 2005
    Location
    Staffordshire, England
    Posts
    101
    Code:
    Dim RS As RecordSet
    
    'Disconnect RecordSet
    RS.Close
    I've been programming with VB for 15 years. Started with VB4 16bit Pro, VB5 Pro, VB6 Pro/Enterprise and now VB3 Pro. But I'm no expert, I'm still learning.

    Martin2k

Similar Threads

  1. Replies: 0
    Last Post: 07-18-2001, 09:36 PM
  2. Disconnected recordset (ADO 2.0)
    By Parimel in forum VB Classic
    Replies: 1
    Last Post: 05-24-2001, 02:38 PM
  3. Disconnected recordset Resync Problem
    By Naunihal Singh Sidhu in forum VB Classic
    Replies: 0
    Last Post: 02-13-2001, 11:09 AM
  4. Re: Disconnected Recordset
    By Scott in forum Enterprise
    Replies: 0
    Last Post: 05-08-2000, 06:17 PM
  5. Append Field to Disconnected Recordset; Please help!
    By Chris Gallucci in forum VB Classic
    Replies: 0
    Last Post: 04-21-2000, 02:48 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center