I have a small "network" consisting of three computers and a "File Server" (peer to peer). This supports an Access 216 database. The server has a file that contains the "Back End" Tables, and each PC (Call them PCA, PCB, PCC) has an identical copy of the User Interface. This has worked well for years.
PROBLEM: All of a sudden some of the data displayed on each PC is different from data displayed on the others. Example: Updating a record on one PC is NOT reflected on the other two [b/]. The same data table can have DIFFERENT NUMBER OF RECORDS on each PC[b/]. Worse: If I open the Back End file on the "server" I find that in many cases the data there is also different from that on some or all the PC's
I HAVE MADE VERY SURE THAT THERE IS ONLY ONE COPY OF THE DATA ON THE SERVER that is accessed by all three PC's
Example The User Interface on PCA can show 100 records for the widgets table and the User Interface on PCB may show 110 records while the User Interface on PCC could have either the same number (100 or 110) or it could have 95 records.
Is it possible that the file server has created separate copies of the same table. I searched using a File Search program but could not fine any copies of the table(s).
Has anyone experienced something similar? This is only happening since I installed Access 2016. It never happened with Access 2003, 2007, 2010, 2013 etc.....
I look forward to hearing your comments.