Forum Discussion

Jason_Hsu's avatar
Jason_Hsu
Copper Contributor
Sep 09, 2021

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's avatar
    Matteo
    Brass Contributor
    Hi,
    Please make sure (1) the Text Format property of the text field in the table, and (2) the Text Format property of the textbox (under Data tab) in the subform are set to "Plain Text", NOT "Rich Text".
    If both are set to Plain Text, can you please post all properties of both (1) and (2) here?
    • Jason_Hsu's avatar
      Jason_Hsu
      Copper Contributor

      Matteo OK I found it..I set it as "純文字"

       

      But I input from the data sheet are also very slow..

       

    • Jason_Hsu's avatar
      Jason_Hsu
      Copper Contributor

      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

       

      • Matteo's avatar
        Matteo
        Brass Contributor

        Jason_Hsu 

        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.

         

Resources