Results 1 to 4 of 4

Thread: Keep Track of Inventory?

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Oct 2010
    Posts
    87

    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.

  2. #2
    Karen Payne MVP kareninstructor's Avatar
    Join Date
    Jun 2008
    Location
    Oregon
    Posts
    6,684

    Re: Keep Track of Inventory?

    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.

  3. #3

    Thread Starter
    Lively Member
    Join Date
    Oct 2010
    Posts
    87

    Re: Keep Track of Inventory?

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

  4. #4
    Karen Payne MVP kareninstructor's Avatar
    Join Date
    Jun 2008
    Location
    Oregon
    Posts
    6,684

    Re: Keep Track of Inventory?

    Quote Originally Posted by sentinelace View Post
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width