I'm working with a rather unusual problem, to me anyway, in an old Access app with shared data tables on a network drive.
The users (using MDEs on Access runtime) were complaining that sometimes their data entries were lost, not listed when they re-open the DB the next day, etc.
Upon examination, we found copies of the DB with the user's PC name in a new copy of the AccessDB file, like AccessDB-Tina-3.mdb, AccessDB-BusOffMgr-2.mdb.
The names of their PCs are in newly created BE tables with the data they thought was missing.
So the data they entered was in the newly created DB, but not in the main DB (path setup to the linked tables) established with the app opens the first time, or when it can't find tables.
There remains the main DB BE (AccessDB.mdb), and 95% of the time the newly created records are stored on this target DB.
Users have been avoiding accessing this DB simultaneously, if that matters.
What might cause this? Using Access 2007.