Database reverts to older version

O

okschlaps

We use a number of Access databases at our work site. Occassionally we find
that we have an old version of records - changes made to records are undone.
My belief is that an old version of the database has been "restored". Our
tech guys swear this is not happening. Is there anything else that could
account for this? Thanks
 
G

George Nicholson

You might verify that people are connecting to the correct BE files.

If you have a split db structure (FrontEnds & BackEnd(s)) then one
possibility is that someone's FE was connected to an alternate version of
the BE data (a backup or some sort of copy, perhaps a local one) rather than
the "live" data when they updated/added records: in other words, the wrong
file was modified.

When subsequently connected to the correct "live" file (or if anyone else
were to look at the live file), those changes would *seem* to have
disappeared from the live file when in reality the changes were made to an
entirely different file. This could easily give the false impression that a
backup of the live file had been restored if they were the only changes made
during a certain period.

HTH,
 
Top