Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

My parents own a small manufacturing business that needs a solution for tracking parts and information about those parts... for example, if someone called in with a serial number they need to know when it was made, who made it, when it was sold, etc... what do most small companies use for this? Is there software out there that helps with this, or should they just use a spreadsheet?

share|improve this question

closed as off-topic by Heptite, Tog, Dave, Kevin Panko, MaQleod Apr 29 '14 at 19:51

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions seeking product, service, or learning material recommendations are off-topic because they become outdated quickly and attract opinion-based answers. Instead, describe your situation and the specific problem you're trying to solve. Share your research. Here are a few suggestions on how to properly ask this type of question." – Heptite, Tog, Dave, Kevin Panko
If this question can be reworded to fit the rules in the help center, please edit the question.

I've been looking for something like this for a while myself. Had to build the skeleton of such a thing waaay back in a VB6 class (I know, shudder) - but haven't touched it since. – warren Sep 13 '09 at 6:00
up vote 2 down vote accepted

Basically you need a database. Excel might do the job for a while, but it'll get messy and very large in very little time. I would recommend using a database. You could start with something like Access (which will let you make forms) or MySQL if you want a free DB, but I don't know what you can get for creating forms for MySQL. SQL Server would be my choice, and there is a free Express version for up to 5 users and reasonable size of data, with seamless upgrade to the full SQL Server should you ever need it.

Then the other option of course it to go on-line with something like Google docs.

There are so many options that I think you might get better answers if you can specify what inputs, how frequently, how many PCs are involved, whether they are all in one geographical location, how many types of lookup are there, and whether they want other reports from the system, such as finding all parts from a particular provider or from a specified batch.

share|improve this answer
Right now it's all in one geographical location, and probably will be for the next year or two at least. Basically I was wondering if there was any prepackaged software for this purpose... I'm considering writing them some software that will do it, but I've got a lot of stuff in the queue right now so I doubt I'd be able to do it in time. From the sounds of it I'll probably just let them do their thing with Excel for a while until I can get them some software to do it and import their spreadsheet into that. – Max Schmeling Sep 13 '09 at 15:35

Not the answer you're looking for? Browse other questions tagged .