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

Jim Lawrence accessd at shaw.ca
Mon Nov 18 13:50:58 CST 2013


Hi Kostas and Anita:

Be patient as I am in the midst of reno-hell...

Jim

----- Original Message -----
From: "Kostas Konstantinidis" <kost36 at otenet.gr>
To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>
Sent: Saturday, November 16, 2013 9:28:28 AM
Subject: Re: [AccessD] problem of a listbox's response on network...

Hi Jim,
could you please post it? It would be very helpful

thank's
/kostas


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

Hi Kostas and Anita:

Just a note: You can just store the list contents in a empty recordset and 
then use the recordset to repopulate the list. If you know the method, 
great...if not and you would like it, I can post it.

I used this method for years when there were many remote users with limited 
connection speeds.

Jim

----- Original Message -----
From: "Anita Smith" <anita at ddisolutions.com.au>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Friday, November 15, 2013 6:00:39 PM
Subject: Re: [AccessD] problem of a listbox's response on network...

Kostas,
I forgot to mention that if your problem is down to network speed then you 
are better off changing your list box to a subform and using the Forms 
Filter property to filter it. That way you are only hauling the data over 
once when the form opens and from then on there should be no additional 
network traffic.

Anita Smith

-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kostas 
Konstantinidis
Sent: Saturday, 16 November 2013 5:06 AM
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 

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



More information about the AccessD mailing list