What are you guys using for Inventory Control? I was thinkning about just making something in ACCESS, but i dont know what is avial.

It really depends on what you're looking for. You can create it in an Access database and, if you out grow it, move to SQL Server. If it's simply counting on a regular basis, that should be sufficient. However, if you're looking to print sales receipts or invoices, keep track of existing inventory and have it modified on every sale, I would do a search for "Point of Sale" products. Intuit (the makers of Quicken and Quick Books) have such products available and really, all that is left is to determine which will best serve you with a minimum of learning curve. All this can be done through Access, but you will need a skilled programmer to design the database, forms, reports, queries, ASP (if you want web-based), etc. for you.

We use access for inventory, sales, and service.

Mike

Intuit has a POS module that allows you to use barcoding to track inventory. I set this up w/ my previous employer. We had a problem w/ "shrinkage". Now all inventory, even small parts packaging was barcoded. The install mgr would scan out all needed inventory billed to the customer as it was staged and scan it out as it left . this cut down on the problem and proved very cost effective. [Link: quickbooks.intuit.com]

This message was edited by emdawgz1 on 10/20/04 11:26 ET.