DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: ADO always open?

  1. #1
    Join Date
    Mar 2005

    ADO always open?


    I have the code:

    SQLString = "Select [Nume firma], [Locatie] From [Email Colaboratori]" & "Where [Locatie] like '" & txtCautare.Text & "%'"
    ElseIf optFirma.Value = True Then
    SQLString = "Select [Nume firma] From [Email Colaboratori]" & "Where [Nume firma] like '" & txtCautare.Text & "%'"
    End If

    Adodc3.RecordSource = SQLString

    The form which has this code is open all the time. After I make the interogation, my ADO is still open? When the ADO is close? Only if I close the form or....there is an another way to do this? I use the ADO control in form.
    I'm interesting in this because I made an VB application (with Access database)which run on a network, and when the appl is open for more clients this run very slowly.

    Could you give me an suggestion to solve my problem?

    Thanks in advance!

  2. #2
    Join Date
    Apr 2007
    Sterling Heights, Michigan
    My advice is to use ADO code rather than the ADO control.

    With code you create a recordset, open it, use it, close it and destroy its instance. I haven't used an actual control in 15 years or so, but I don't believe you have that kind of flexibility with it.

Similar Threads

  1. ADO Recordset
    By deepa george in forum VB Classic
    Replies: 11
    Last Post: 08-21-2002, 08:20 AM
  2. ADO - Open Access with password
    By Alex in forum VB Classic
    Replies: 3
    Last Post: 07-10-2002, 08:46 AM
  3. Replies: 0
    Last Post: 04-29-2002, 03:33 AM
  4. Open source projects, open source resources
    By Anonymous in forum Open Source
    Replies: 0
    Last Post: 01-29-2002, 10:41 PM
  5. Replies: 0
    Last Post: 09-01-2000, 11:40 AM

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
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

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