New Project time. I work at a printer and we need to schedule jobs in half-hour blocks from 8 am to 5 pm, upwards to three days in advance. We have six printers that can, with time out for paper replacement and project rolling, spit out 350 sheets per hour. It needs to be placed on our network in such a way that upwards to ten people in three departments (intake, production and shipping/delivery) can make notations and those notations will register almost immediately (the program will be open on each of our desktops). Jobs which are not marked as complete by an hour after their due time should be moved to a pending section. Each morning (or afternoon) a new day will have to be created (from a template?).
I have looked at alternatives to Access for this project. Microsoft Project doesn't--easily--go to small enough time increments. Excel isn't network friendly enough for us to leave it open. But I'm open to suggestions.
How much of this can be automated? Should a new table be created for each day? Or can the database be designed to roll over the template based on the system clock? Possibly a more realistic question: Am I nuts?
This idea is just in the planning stages. I hope to work on it in earnest next week and put a prototype up by the first of September.