We have an Access front end with a SQL Server backend. We have inventory that we need to scan and keep track of. Is there a way to scan barcodes into a SQL Server table? I'm not sure if it would be better to use a tablet or phone scan or something else. We are looking to scan the inventory to the backend SQL table and then be able to view it in MS Access front end and track inventory. Any ideas on the best way to do this is appreciated.
There are two basic types of scanners: Those that scan and store into their own memory and those that scan and store to some memory over wifi or physical connection.
"Hey! I see it's a bit old discussion, but I would like to chime in. One option is to use a mobile device such as a tablet or phone with a barcode scanner app. You can then connect the device to your SQL Server database and use an app or web interface to scan and input the inventory data directly into the database. Another option is to use a barcode scanner connected to a computer and a program such as Microsoft Access to input the inventory data into the SQL Server database. Or you could use the alternative app, like smartengines.com . I hope that helps you. "