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.