Hello all,
I have little experience with MS Access but at my new job my boss has built some great databases and this has inspired me to try and build my own to make my job easier. Sadly my boss can’t help me with this because he does not know the answer either and before I start with learning all I need I want to know if this is possible.
I work in the food-industry and for certain customers and certification standards we need to make sure that all the documents used on the floor are the latest version of the document and that the document is authorised by the “owner” of the document.
So what I want to build is a Document Filing System, simple enough to start with right.
But the thing I want is the following:
• A new version of a document is added to the database
• The owner of the document receives a notification (like an email)
• The owner goes in the database and checks the document and if this is says its okay to use by putting a time stamp in the database. This time stamp should be password protected or something.
Is this possible in access?
Hopefully I am clear enough, I have a very clear picture in my head what I would want but it’s hard to get on (digital)paper
I have little experience with MS Access but at my new job my boss has built some great databases and this has inspired me to try and build my own to make my job easier. Sadly my boss can’t help me with this because he does not know the answer either and before I start with learning all I need I want to know if this is possible.
I work in the food-industry and for certain customers and certification standards we need to make sure that all the documents used on the floor are the latest version of the document and that the document is authorised by the “owner” of the document.
So what I want to build is a Document Filing System, simple enough to start with right.
But the thing I want is the following:
• A new version of a document is added to the database
• The owner of the document receives a notification (like an email)
• The owner goes in the database and checks the document and if this is says its okay to use by putting a time stamp in the database. This time stamp should be password protected or something.
Is this possible in access?
Hopefully I am clear enough, I have a very clear picture in my head what I would want but it’s hard to get on (digital)paper