Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Barcode inventory/asset system

Barcode inventory/asset system

Barcode inventory/asset system

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

Geeze, yes, heck, if you already have an asset database in access, why not merely enhance it to do what you need it to do, to print bar coded labels (very easy to do) etc etc.  

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

While I realize this is a little late, I want to second James529's suggestion of simply integrating the bar codes with your existing database.  This is minimal work, and much easier than switching inventory systems, using two separate inventory systems, or trying to integrate two different inventory systems.

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

I tried to get assets and Symbol barcoder working with out any luck, I mean reading.  Back in the DOS day I could get Advancerev. to print file cover with bar codes, so windows should be able to print labels?

Never give up never give in.

There are no short cuts to anything worth doing   smile

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close