Hello all!
I hope this is not to difficult to solve, but I have an idea on this but I don't know if its wrong or right or if there is a better way I can do this.
I have an access 2007 server with 10 people connected to it constantly updating it daily. Everyone has a front end on their laptops and I am the only one who can edit and change the back end. Everyone uses a form to input data and and that's it, they can only view the table that the data is entered.
But we have a data that must be approve before it can be entered into the database. I have figured i can make a separate database for this. This data is written up on white boards and is posted on he share server and looked at and it gone through 3 levels or editing and approval. It is then entered into the database. After a few weeks we erase these white boards and start over. So i cant use my existing database to create relationships with this because the data cannot be inside the database yet until approved.
I am looking for a way to solve the constant movement of everyone in the office to have to go up to the white boards to show the status of that data. And I want to use access to be able to do the same job as the white boards that shown the status of each item needing approval.
Any input would be greatly appreciated, thank you.