I am writing my first complex VB2010 program that is a order entry and inventory management program. I know there are lots of these out there. However I'm attempting to write this for a specific type of business which creates its own set of challenges. However my question has only to do with storage and retrieval of all of this data that will be created. I am trying to accomplish a several things. So I would like your input on what products to use to store the data.
I do want
1) a product that will allow easy changes to some of these database fields using EXCEL (this product is easy to use and the masses seem to understand it)
2) I need to ensure that the individual "columns" of data can be made to accept changes made manually, whereas others need to be "locked" such that they can only be altered as a result of program (as an example, I want to allow manual changes to the description of a part number. However how many that are sold during a given month should only be altered by the program that controls order invoicing).
To get a better grasp of what I'm doing, please don't hesitate to ask questions. Ultimately I want to make this program simple to use by the end user.
In advance, thanks for your input.