Results 1 to 7 of 7
  1. #1
    Antonww is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Nov 2017
    Posts
    4

    Inventory System in Access

    Dear All,



    I am new to access and want to create an inventory system in Access.
    Please consider that I am very basic user.

    Following are my requirements

    01. I want to create inventory items and I want to add around 5 pictures of each inventory item. Is this possible in access?

    02. Can we give access control for different users?

    Hope someone will help me.

    Thank you

    Anton

  2. #2
    Minty is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    What you want is perfectly achievable in Access, but is not a beginners project I'm afraid.
    If you need this as part of a functioning business requirement, either buy something off the shelf, or be prepared to pay someone to do it for you, and allow at least 3-6 months depending on your business needs.

    If you are doing this as a learning project allow at least a year to get it vaguely right, unless you are very skilled and have nothing else to do.

  3. #3
    Antonww is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Nov 2017
    Posts
    4
    Quote Originally Posted by Minty View Post
    What you want is perfectly achievable in Access, but is not a beginners project I'm afraid.
    If you need this as part of a functioning business requirement, either buy something off the shelf, or be prepared to pay someone to do it for you, and allow at least 3-6 months depending on your business needs.

    If you are doing this as a learning project allow at least a year to get it vaguely right, unless you are very skilled and have nothing else to do.


    Dear Minty,

    Thank you very much for your reply.

    I like to do this as a learning project also.

    Can you please give me an idea on how to add a picture(s) of inventory items?


    Thank you in advance

    Anton

  4. #4
    Minty is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    You can store pictures as an attachment field in Access, I would NOT do this however as it will cause the database to get very large quite quickly. Access DB files can only be a maximum of 2Gb.
    Make sure each item your inventory has a unique ID. Store the pictures of your inventory in a format like UniqueID.jpeg . You can then easily create a picture file path without having to store it.
    Store the top level path as a field in a system table.
    If you ever move the storage location you only need to update one field in one table, not edit thousands of records.

    You can display the picture in an embedded image holder.

  5. #5
    Antonww is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Nov 2017
    Posts
    4
    Dear Minty,

    Thank you very much for your quick response. I think my problem is solved.

    Thank you again

  6. #6
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Anton,
    As minty advised, Inventory database applications are not trivial. Storing images within the Access database is not considered good practice by most developers. In order to get some idea about the design and development of a "stock control application" watch this free video from youtube. You should also research (Google/Bing or forum search) and review various threads/posts on Inventory Control/Stock Control/Inventory Management etc.
    If you are keen to use inventory as a learning project, then some of the links on this page may be helpful.
    Do your planning and analysis. Do NOT be too quick to jump into physical Access database.

    Good luck.

  7. #7
    NoellaG's Avatar
    NoellaG is offline VIP
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,035
    Hi,

    another consideration when building a storage/warehouse solution (I build quite a few of them in my career): I started the first one using Access, but pretty soon found out I needed a more solid system and switched to SQL server as the back-end. You can still use Access to build the front-end application if you want.
    Don't forget that most storage systems use scanners (which you can do using Access) for input and output of items.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 10-01-2016, 04:15 PM
  2. Creating an inventory system using Access.
    By Jeffrey55 in forum Access
    Replies: 1
    Last Post: 03-31-2015, 01:00 PM
  3. Inventory Control System
    By egorzik in forum Database Design
    Replies: 2
    Last Post: 02-10-2014, 07:53 AM
  4. An inventory system
    By stew8908 in forum Access
    Replies: 3
    Last Post: 05-08-2012, 05:50 PM
  5. Inventory System
    By Rawb in forum Database Design
    Replies: 8
    Last Post: 01-05-2011, 07:26 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums