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

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

Re: Database is "losing data"

Show all headers | View raw

On 7/2/2015 2:49 AM, Phil wrote:
> 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
>

Backup was the first thing we thought of. But IT department SWEARS it's 
not the backup routine.

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