This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I am building an item->location database and I want to use QR codes to keep up with the item and what location they are in. I have built the tables with the items and locations but I'm having trouble figuring out the best way to get them connected with QR without going to a 3rd party program. I need this to work without internet as part of the locations are out of service.
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more
need this to work without internet as part of the locations are out of service.
scan them with a mobile
if you can scan with mobile,why not connect internet through mobile service with WIFI.
And qrcode are often used to connected internet for fetching info.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 51%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
You could use a tablet that runs Windows and scan directly to Access. Or you could use any device that will scan and store the scans then upload to a PC. Or you could use a wand that has storage.
But none of that is specific to the barcode type used. I've worked with a few apps, that scan a barcode and a QR is too complex for this application.
This is pretty much the conclusion I have come to after weeks of research... We wanted to use QR codes so that we could just scan them with a mobile device like an iPad and not have to carry the external scanners.
I very much appreciate your advice on this project!
Why QR codes? QR codes are designed to hold a lot of data in a 2 dimensional format. But you nee software to generte the QR codes. While regular barcodes can be generated by using a barcode font. It would be easier to attach a barcode to an item, scan the barcode, then scam a location barcode to indicate the current location.