MS Access 2007 unable to save - data lost
Posted on 2012-08-28
Hi, we had a network hiccup for 10 minutes and when a user tried to resave the MS-Access table to the SBS 2011 network drive where they reside he got the following message.
"Your network access was interuppted. To continue close the database, and then open it again."
We are unable to save the database, tables or objects locally as it gives the same message.
So we have had to close the database down and start again.
1. Why doesn't Access resuem when the connection resumes?
2. I can't find an auto-save facility in Access, like Word or Excel.
3. We seme to have lost all the updates since the last forced save.
A lot of people seem to eb reporting this style of problem going back to Access 2000. What is the work around so that we don't have staff losing data that they have typed in.