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

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

Re: Database is "losing data"

Show all headers | View raw

On 02/07/2015 10:38:38, Optimist wrote:
> On Thu, 02 Jul 2015 03:12:23 -0500, Neil <xxx@gmail.com> wrote:
> 
>>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.
> 
> Is there a log of changes showing date, time and user?
> 

If there was a printout of the changes, as the OP reported, then I would have
thought that was pretty concrete evidence that they had been done.

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