[AccessD] problem of a listbox's response on network...

Thank's Jim



-----Original Message----- 
From: Jim Dettman
Sent: Saturday, November 16, 2013 8:02 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] problem of a listbox's response on network...


You also might want to try adding a connection to the back end DB that
exists for the life of the app.

  This avoids repeated closing/opening of the BE.   You should keep a
connection open for each BE if you have more then one.  Simplest method is
to open a hidden form at startup, but it can be anything; DB open in code,
open a record set on a linked table, or whatever.

Jim.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kostas
Konstantinidis
Sent: Friday, November 15, 2013 01:06 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] problem of a listbox's response on network...

hi to all,
I am working on a mdb file (office 2010) under linked tables from another
database which is installed on a home network (workgroup 192.168.0.xx)
For quick searching on basics fields (name, year born etc) every user on the

network is working with a deigned form including an unbound list box

on a text unbound
Private Sub text_box_Change()
Me![list2].RowSource = "SELECT [AM], [Last_name], [First_name],
[Father_name], [year_born] FROM [q_start_list] WHERE [Last_first_name]like
'" & Me![text_box].Text & "*'"
End Sub

on a button
Private Sub list2_DblClick(Cancel As Integer)
    Dim stDocName As String
    Dim stLinkCriteria As String
    stDocName = "MT_basic_char"
    stLinkCriteria = "[AM] = " & Me!list2.Value & ""
    DoCmd.OpenForm stDocName, , , stLinkCriteria
End Sub

what it happens... if only one person is connected working on the listbox
there is no problem at all while the response returns on the spot
But when more than one try to work on the same listbox the response is
ridiculously slow...

Is there any idea about which is the reason it happens?

thank's in advance
/kostas

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com