[AccessD] Honeywell scanner

[Jim Dettman]

Bob.

 Is the scanner RS232 based?   That's usually the reason for using a VB as a
front end.

 The mscomm control came with VB and it will work with Access, but it's not
licensed for use with Access.

 I'm actually dealing with something similar now.   Have a weigh bridge in
Australia that uses a VB6 app for the comm part and controls Access via OLE.
They want to update the Access side, but can't.

 I've come up with some WinAPI code to drop into Access to do the RS232
part.  If it works, then we're going to drop the VB6 part entirely.

Jim.

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bob
Heygood
Sent: Tuesday, November 28, 2017 11:31 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Honeywell scanner

Looking to see if someone here has used a Honeywell Barcode Scanner with
Access.
I have inherited an old Access program that uses the 9520 scanner.
Unfortunately, someone somewhere along the line decided to use a VB front
end on the old A97 database.
Other than the use of the scanner and maybe too lazy/cheap to upgrade
Access/Office, I don't know why they used the VB exe to interact with the
db.
My idea is to convert to at least A2010 and ditch the exe. Would be nice if
I could expect the bar code reader to function. A am on the trail of a
driver for this piece of hardware.
I have done bar code reader integration with Access before.

Bob H

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com