I have a PPT2700 handheld terminal with a built-in scanner. It is internet connected and on a LAN that has an MS Access database. What I need is a program that when the scanner is activated the scanner reads the barcode data, associates it the barcode with the field that matches the barcodes numeric value in the field 'item number' in the database, and displays the data from that row in the database. The displayed fields need to be editable so that the data can be modified and submitted back to the database, updating the fields with the modified data. The database only has 12 fields in each row. I have attached the database file below so you can see the exact database the program will be accesing.
I forgot to add the device is a Windows CE device, NOT a PALM device.