Minimize lag for data entry on combobox bound to remote table. (1 Viewer)

[raziel3]

I have a combobox that uses a barcode scanner for input. This is bound to a linked table on another PC on the network.

The problem I am having is that after scanning, the combo box takes long to fill with the barcode. In latency terms, after scanning one item and I go to scan the other the first item is still being populated into the combo box and at times the 2 barcodes gets merged into the combobox.

I've already tried suggestions in this link
https://www.fmsinc.com/microsoftaccess/Performance.html#Linked Tables

like keeping the table open
https://www.fmsinc.com/microsoftaccess/Performance/LinkedDatabase.html#OpenDatabaseID

Can anyone advise me what other things I could try?

 

[pbaldy]

Depends on the specifics of what you're doing. One option is scanning into a local table and then processing the scanned items into the linked table at the end. If the combo is just being used to look up a second field, another option is to load a copy of the linked table locally and point the combo to that.

 

[raziel3]

Yes, the combobox is referencing a second field. I don't think that having a local copy of the link table is possible as other users updates data on it during the course of the day.