Card reader data to Access database (1 Viewer)

[MW]

I need to read data from an electronic card reader into an Access database. Employees scan their card on arriving/leaving the building. This currently feeds into a 3rd party database which is old and fairly useless. I want to make a new Access database, but don't know how to make the data feed into it.

Thanks

 

[DES]

Depends

On how the card reader is set up.

The ones I have worked with require a single line of code in the Autoexec.bat to make them work. Once a card is run through the reader it dumps the card information into whatever is open.

Test it by running a card through the reader with notepad open to see what you get.

Once you have it so that notepad is receiving info then just go into access and set up a form with a text box on it. Run the form making sure the text box has the focus and run the card through again. At this point the card's data should be dumped to the text box. All that is left to do is pull the info from the text box that you want.