Forum Discussion
Regarding the input speed
Hello. please teach me How do I set ACCESS database to make the scanner input fast as in Excel? Thank you..
Matteo Thank you for your reply
I'm not sure where is "Plain Text" setting you said.. please see the below screenshot. Is this the place you are talking about?
Thank you
Based on your screenshot, I noticed another thing, which probably not directly related to the slow entry., but I wanted to mention. The "Order By" in table properties have BarcodeID and Location fields listed. I would recommend them to be moved to Index instead, which makes indexing faster. You need to define one index name, but you can list more than one fields, see example below. Primary key is indexed automatically, then I added MyIndex for two fields;
You can do the same for Location ID and Barcode.
- Thank you so much for your help
JASON