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

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

Re: Database is "losing data"

Show all headers | View raw

On 02/07/2015 09:12:23, Neil 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.
> 
> 

Well, plainly there are 2 backend databases- the updated one and the old one.
So it would seem logical to search the whole of the network for files with a
name like your backend database. I say "like" because in my backup routine,
for example, the backend is WFYCTab2010.AccDb and the backups are naqmed
something like WFYCTab2010 07 November 2011 11 07.zip
WFYCTab2010 07 November 2011 11 07.Bak
WFYCTab2010 End Year 24 November 2013 15 52.Bak.
Obviously the zip file can be unzipped and the .Bak files renamed if
something needs restoring.

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