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, 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.



"Burnt out after 20 years in IT" wrote:

> 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?

hi,

On 05.04.2010 17:32, Burnt out after 20 years in IT wrote:
> 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 <--