How to scan bar codes into an Access 2007 database.

We are currently creating an audit database in Access 2007, we need to be able to scan in equipment barcodes into our database. We would like to be able to use our handheld scanner to read in  the barcode data, into one of  our Access  tables, please can you help on how to interface our scanner to our database.
Who is Participating?
Brian PierceConnect With a Mentor PhotographerCommented:
Most scanners work by emulating keyboard input, so its a matter of rigging up the scanner and scanning the barcode at the same point that you would nomally enter the code via the keyboard.
clarkscottConnect With a Mentor Commented:
Bar code scanners act just like your keyboard.
You can focus on anything; Access field, notepad, word doc,..... anywhere.
When you scan the barcode - the value will appear where the cursor is focused.

That's all there is to it.

Scott c
A little bit OT, but
the problem will be, how to determine if the user is just typing in some data with the keyboard
or if he is trying to scan in some barcode !!
Dbrooks-smithAuthor Commented:
Thank you very much for your help.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.