Thanks in advance for helping a newbie trying to become something...
I've created a database for use amongst 3 Production departments. The database is on a shared drive on a corporate server. How do I handle the saving of the data if all 3 departments decide to input into the database at the same time? Prior to this, all my db work was for a single user doing input. I now will experience multiple users, but don't want to lose info if all 3 are at different terminals, accessing the database at the same time and trying to input their required data.
Any suggestions? I don't know how to begin to handle this, especially once the database is created and functioning. Until this point, I've been the only person doing the data input. I want to transfer input responsibility to my direct reports.
Thanks
I've created a database for use amongst 3 Production departments. The database is on a shared drive on a corporate server. How do I handle the saving of the data if all 3 departments decide to input into the database at the same time? Prior to this, all my db work was for a single user doing input. I now will experience multiple users, but don't want to lose info if all 3 are at different terminals, accessing the database at the same time and trying to input their required data.
Any suggestions? I don't know how to begin to handle this, especially once the database is created and functioning. Until this point, I've been the only person doing the data input. I want to transfer input responsibility to my direct reports.
Thanks