I have been considering writing an application for collecting labor from our plant floor.
I would like to write this application using MS Access 2010. It would be deployed to about 25 workstations as an .accdr file along with MS Access 2010 runtime.
I would like to store the data tables in an SQL Server database, linking to them using ODBC.
Basically it would collect 4 types of transactions:
1) Clock IN time for the day.
2) Clock ON time for jobs.
3) Clock OFF time for jobs
4) Clock OUT time for the day
Each worker has a unique badge ID and would be entering their own data. They will all be appending to and updating the same tables but no two workers will ever be updating the same record in these tables because of the unique badge ID.
My concern is at the end of the day when everyone clocks OFF of jobs and OUT for the day on these multiple workstations simultaneously. Is there going to be problems caused by multiple users appending and updating these tables at the same time?
Any thoughts or suggestions would be appreciated.