Can you collect data into access 2007 using barcode scan guns?

[Burnt out after 20 years in IT]

Can you setup an access database to accept barcode scans? We are currently
using tcp/ip for data collection into sql and wanted to know if Access 2007
can handle it?

 

[Daniel Pineault]

Yes, it can be done very easily. Scanners are simply I/O to the db so you
can set them up to input data into a given control on your form just like a
keyboard would.

One reference on the subject can be found at
http://www.devhut.net/index.php?lang=en&pid=0000000032
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Stefan Hoffmann]

hi,

Can you setup an access database to accept barcode scans? We are currently
using tcp/ip for data collection into sql and wanted to know if Access 2007
can handle it?

Yes, but it also depends on the type of the scanner. Basically there are
two types:

Keyboard input device scanner directly insert the scanned barcode into
the active text box.

Store and forward devices store the scanned barcodes and you need to
download them mostly as a text file and parse/process this file.

So depending on your needs you should evaluate the available devices.
The best I have used so far are the MetroLogic devices, but they are
also one of the most expensive ones.


mfG
--> stefan <--