Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-access > #10894

Re: Database is "losing data"

Show all headers | View raw

On 02/07/2015 07:38:03, Optimist wrote:
> On Wed, 01 Jul 2015 20:08:08 -0500, Neil <xxx@gmail.com> wrote:
> 
>>I have a strange situation. A client is claiming that their Access
>>database is losing database edits. For example, someone goes in,
>>modifies a few records, adds a few others, saves, prints the records,
>>and then, a few days later, his changes are gone. The new records aren't
>>there, and the edited records are back to their pre-edited state.
>>Sometimes changes are lost later the same day that they are made.
>>
>>I tried to explain to the client that there's nothing in Access that can
>>revert a record to a pre-edited state; that Access doesn't cache data
>>changes. But their IT department is claiming that nothing's changed on
>>their end, so it must be the app.
>>
>>I shared with the client that, somehow, an older copy of the back end is
>>replacing the updated back end, and that's why the changes are lost. But
>>they can't figure out how.
>>
>>I did share with them that this might happen with a replicated server
>>drive. But I don't know if that's what they have there.
>>
>>So I just wanted to see if anyone had any other thoughts about what
>>might be going on here. Also, I just wanted to confirm that there's
>>nothing within Access that can revert changes back to a pre-edited state
>>after data has been saved. I've been working with Access for close to 20
>>years, and I've never heard of anything like this before. Still, you
>>never know....
>>
>>Application is a split front end/back end Access 2010 ACCDB file. Both
>>files are located on the server, and front end is share among a handful
>>of users. Probably no more than 2 or 3 people at a time would be using
>>the database. (I advised them to put the front end on each user's
>>machine, but they didn't.)
>>
>>Thanks for any input!
>>
>>Neil
> 
> Perhaps a rogue application linked to the back end tables?
> 

Is a backup of the back end database being made, and if so is there any way
the data is overwritten by the backup? Don't forget that backup could be of a
folder containing your database as well as other files.

Phil

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Database is "losing data" Neil <xxx@gmail.com> - 2015-07-01 20:08 -0500
  Re: Database is "losing data" Optimist <v.meldrew@i.do.not.believe.it> - 2015-07-02 07:38 +0100
    Re: Database is "losing data" "Phil" <phil@stantonfamily.co.uk> - 2015-07-02 08:49 +0100
      Re: Database is "losing data" Neil <xxx@gmail.com> - 2015-07-02 03:12 -0500
        Re: Database is "losing data" "Phil" <phil@stantonfamily.co.uk> - 2015-07-02 10:34 +0100
        Re: Database is "losing data" Optimist <v.meldrew@i.do.not.believe.it> - 2015-07-02 10:38 +0100
          Re: Database is "losing data" "Phil" <phil@stantonfamily.co.uk> - 2015-07-02 11:07 +0100
            Re: Database is "losing data" Optimist <v.meldrew@i.do.not.believe.it> - 2015-07-02 14:45 +0100
              Re: Database is "losing data" Neil <xxx@gmail.com> - 2015-07-02 14:42 -0500
                Re: Database is "losing data" Optimist <v.meldrew@i.do.not.believe.it> - 2015-07-03 07:53 +0100
  Re: Database is "losing data" Ulrich Möller <knobbi38@arcor.de> - 2015-07-02 13:28 +0200
    Re: Database is "losing data" Neil <xxx@gmail.com> - 2015-07-02 14:43 -0500
  Re: Database is "losing data" "martygrantnc@gmail.com" <lists@martygrant.com> - 2015-07-02 19:31 -0700

csiph-web