Updating listbox in real-time

[engabinga]

I have a program that uses MS Access as the backend and a VP app as the frontend. The app is used by 3 users and has thousands of records that need to be accessed by all 3 users. The program works fine, but I would like to make improvements to it, by updating the data in real-time. I currently fill a listbox with the thousands of customers.

My question is if user1 adds a new customer is there a way to update the list for users 2 & 3 without having to refresh and refill the list? I can't update it every n seconds/minutes because it takes to long to repopulate.

Thanks in advance.

[jim mcnamara]

You can keep a temp table in ACCESS that lists current adds/deletes - then just use .Additem once every minute to insert a few records into the LB? Instead of re-reading all of the items.