Welcome, thank you for your answers so far.
Here is a more detailed description of my project, maybe I did not focus enough on it.
We have several machine locations on our shop floor (for example, friction welders, hot crimp stations, etc.).
Currently, these stations use a paper sheet to track their progress for each work order identified by a unique order number.
This sheet contains several characteristics that the operator must test at a predetermined interval to ensure that the parts meet the specifications.
Now the problem is this.
1. It can happen that a part does not meet the specifications, but for some reason the operator does not recognize it as such and continues working.
2. the wrong components for the part are delivered to the station and the operator simply builds a part with the wrong specifications.
3. not every part can be produced on every friction welder, which can cause problems.
To prevent this, I have programmed a form that represents the inspection record. I have a table that holds the parts with all the necessary information. (length, length after welding, sub-parts, etc.).
When the operator enters the data, the system checks against the data in the table and makes sure the part meets the specifications.
Back to my problem
I have seen that there is an offline mode offered by SharePoint, but my problem is rather that it can happen that the computer simply loses any connection to the Internet due to lack of a bad connection. Unfortunately, there is no LAN connection to the kiosk station where the operators enter the data. When I tried to enter data into my form and then just disconnected my computer from any internet connection I got an error saying "Access cannot connect to SharePoint list" which makes sense since I just turned off the internet. also I came to notice that the SharePoint connection requires quiet a good internet connection as otherwise the working speed suffers severely.
What I would like to have is, and sorry if I use the wrong terms to describe it properly, I am still learning, almost like a local backend that stores the data that is typed in and also the tables that hold the data that is necessary to complete the compare operations.
then every for instance 15minutes i want the computer to check if its connected to the internet. if yes, upload the data to a sharepoint list (i dont necessairily use sharpoint, that was just one of the first online sharing methods i came across.) if it is not, we just dont upload the data and wait 15minutes.
The data entry should not be too frequent, maybe 7 entries per hour. so we might only need to upload like a few records each time.
The excel sheet is just used to have a nice tool to look up the data because it offers creat filter capabilities.
Thanks again for your help, it's much appreciated.
Regards.
Fjell