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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Brian PiercePhotographerCommented:
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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.