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

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

Re: Database is "losing data"

Show all headers | View raw

On 7/2/2015 8:45 AM, Optimist wrote:
> On Thu, 2 Jul 2015 11:07:16 +0100, "Phil" <phil@stantonfamily.co.uk> wrote:
>
>> 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.
>
> But is the date of the last log entry on the database before or after the printouts?
>
No, no log of changes. But I'm almost certain that no one is going in 
and changing the data back. Only two or three people have permission to 
make these edits, and it's doubtful that any of them would go in and 
undo the edits that were done. So, even if there were a log, I don't 
think it would show edits after the printouts (though it would be good 
to have that anyway). Pretty sure the old be is just somehow replacing 
the new be.

Thanks

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