I had today experienced an interesting problem, where by some users when opening an Access file on the network and tried opening the tables, got an error message, "Disk or network Error", however this did only happen to a few, while the majority of users didn't experience this, now my questions are:
A- What is the cause of it?
B- What is the solution?
C- How can I avoid it in the future?
D- Is it safe to run a batch file on schedule every hour to make a copy the Access file, so in case of an error, I can simply replace the file with the latest backup?
FYI- This file is the BE where all the tables of my FE App reside.