I am trying to set up an auction site in Access 2010. The database has a table (no backend db) with item name, bid amount and bidder number. The form allows the bidder to enter a bidder number from a listbox and a bid that is higher than the current bid. The database is on a network computer and other computers can use the same form via the network. When someone updates the main computer bid, the bid updates the table immediately (Me.Requery). But, the update flows to other computer's forms slowly. The other computers, using the same form, work the same way, EXCEPT it takes from 20 to 54 seconds to update the table and other computer's forms. There seems to be an automatic update process that updates the textbox data in other compter's forms that is working very slowly.
I have also tried a separate "computer" using VirtualBox on the main Win10 computer with slow results. I thought it would be instant since the VB is on the main computer that does instant updates, but it is almost as slow as a separate networked computer.
My question: Is there an Access solution that can cause the input to flow faster to the table and on to other computer form's textboxes that currently show old data for many seconds before updating? The process works fine, it is just slow and I have no idea why.
Thanks,