Barcode inventory/asset system
Barcode inventory/asset system
(OP)
I'm looking for a system for keeping track of around 250 computers and monitors using a barcode system. We allready use a Microsoft Access database for our inventory, but want to be able to put barcodes on the computers so we can keep track of where they are and to make inventory management easy. Right now we have looked at the skandata system and the kwikasset program. Do you guys have any other suggestions? Maybe just a scanner and label printing program we could integrate with the Access database we allready have?
RE: Barcode inventory/asset system
Alternatively, you can just purchase pre-printed bar-coded asset tracking labels or tags and focus on the data collection and integrating that to your database.
Of course, the only advantage you have using bar code asset tracking as opposed to labeling the assets with a label with a number on and inputting the info manually is the collection of the asset number using a scanner (naturally you will probably need to input the assets location or other attributes, maybe even the software and version installed in case of a PC). You could do this with a laptop with scanner attached scanning directly into your Access database tracking system or by using a portable scanning data collection device and uploading the data to your database as necessary.
Alternatively, you could use something like a symbol SPT PDA with scanner and with a simple program written for it do all your asset data collection.
In any event, since you already have an asset database in access, your more than half way there and need only to address the labels and data collection techniques.
If you do it yourself, you will have complete control over how it works including ongoing enhancements which in my opinion is always better than off the shelf software unless your not equipped to do any development work or have simple requirements that won't change much down the road.
RE: Barcode inventory/asset system
You do not even necessarily need to include bar code printing capability into your database. There are several off-the-shelf bar code printing applications that can read the data from your database tables. It's a little more money, but less effort recreating the wheel. (I happen to like a program called BarTender, but there are several options available.)
RE: Barcode inventory/asset system
Never give up never give in.
There are no short cuts to anything worth doing