Keep Track of Inventory?

Anyone ever set anything up to keep track of inventory?

I need to check 1 time a month:

Printers
Barcode scanners
labels
etc.

Am I just best to use Excel or is there better options?

I need to keep track of repairs, part replacements, and orders.

It all depends upon how much inventory you are tracking. For instance if you had say 1,000 items to track perhaps MS-Access would be suffice although you really need to keep the MDB in check by compacting it and also backing up the database. Another option is to store your data in a relational XML database where the table relationship is no different than how you would setup table relations in a database. The downside to using XML is that you may end up with more code. The best option no matter how large you inventory is would be to use something like SQL-Server or similar type of database. I would not recommend Excel simply because there is always the possibility that if you end up using say macros or code that does not play well with a newer version of Excel you could end up with conversion issues. This comes from experience were users used Excel to keep track of whatever in one version of Excel then moving to a new version of Excel various things stopped working. But I do not know all your requirements so may be Excel is fine especially if you are not using .NET as a method to store and retrieve information if you are using Office automation we head back to issues when moving from one version of Office to another version of Office. When I have no choice my method to access and store data to MS-Excel is Aspose Cells library which when used correctly you do not rely on what version of Excel the user has and if they do not have Excel it does not matter as the Aspose cells library works without Office.

I have a 2008 R2 SQL server. How would I go about in getting this setup?

Quote:

---

Originally Posted by sentinelace

I have a 2008 R2 SQL server. How would I go about in getting this setup?

---

Here are some links to get you started.

sql server 2008 r2 requirements
http://msdn.microsoft.com/en-us/library/ms143506.aspx

Using SQL-Server with VB.NET
http://www.google.com/search?hl=en&r...=&oq=&gs_rfai=
http://msdn.microsoft.com/en-us/vbasic/Video/bb643821
http://msmvps.com/blogs/deborahk/sea...er&o=Relevance
http://msdn.microsoft.com/en-us/vbasic/bb688085