Database and inventory software
What do you use to track wood inventory?
If you forsee a time when you want to share the database with other users over a network, I would go with Filemaker Pro. Access has lots of problems with networked, multi-user systems.
Word is that MS is replacing Access in the near future too (about a year or so), so I would feel more comfortable with Filemaker Pro.
Pardox is good if you want a beefy desktop database, but it isn't as easy to use as Filemaker Pro.
For a good contact manager, you may want to use ACT! or Goldmine. Great for customer databases, without having to learn database concepts.
I would use MS Access. It is very powerful and can be easily modified for other things. I am an Access and Visual Basic Programmer for a hardwoods company.
From the original questioner:
Do you have any tips on using Access for inventory? What about tracking specific logs and planks of logs?
Another alternative is to enter and maintain your customer list and information in Outlook Express of Outlook 2000. Outlook has the capability to customize your database fields.
You can do a mail merge into a MS Word document for mailings.
Outlook also lets you "journal" information about your customers and related information that you want to be able to retrieve by customer.
I am currently working on a tracking/inventory system using Microsoft SQL as the database. It will track each board as an individual entry.
The comments below were added after this Forum discussion was archived as a Knowledge Base article (add your comment).
Comment from contributor A:
In response to the other replies... I would not recommend Access or basic spreadsheets for any system you feel will be growing in the near future. An SQL type database is an excellent choice. Although some applications have excellent proprietary databases also.
If anyone is into playing around with the operating system Linux, try taking a look at some PostgreSQL and MySQL based applications. A real promising, free one is sql-ledger accounting.
Would you like to add information to this article?
Interested in writing or submitting an article?
Have a question about this article?
Have you reviewed the related Knowledge Base areas below?