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

Groups > comp.databases.ms-access > #10892 > unrolled thread

Database is "losing data"

Back to article view | Back to comp.databases.ms-access

Contents

  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

#10892 — Database is "losing data"

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

[toc] | [next] | [standalone]

#10893

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?

[toc] | [prev] | [next] | [standalone]

#10894

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

[toc] | [prev] | [next] | [standalone]

#10895

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.

[toc] | [prev] | [next] | [standalone]

#10896

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

[toc] | [prev] | [next] | [standalone]

#10897

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?

[toc] | [prev] | [next] | [standalone]

#10898

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

[toc] | [prev] | [next] | [standalone]

#10900

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?

[toc] | [prev] | [next] | [standalone]

#10901

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

[toc] | [prev] | [next] | [standalone]

#10904

On Thu, 02 Jul 2015 14:42:30 -0500, Neil <xxx@gmail.com> wrote:

>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

Have you tried monitoring the modified date in the file properties?

[toc] | [prev] | [next] | [standalone]

#10899

Am 02.07.2015 um 03:08 schrieb Neil:
> 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

Hi Neil,

i would trust the IT department for their  backup/restoring process, 
because normally only the administrator will be able to restore a file 
or a folder. But has anyone considered the "Offline Feature" of a shared 
network location of the clients. Perhaps there exists a client which is 
not always attached to the network or has some trouble with the network 
connection and has enabled this feature. It could be possible that this 
client makes a resync on the mapped files when the connection is 
reestablished after an interruption.

Just an idea...

Ulrich

[toc] | [prev] | [next] | [standalone]

#10902

On 7/2/2015 6:28 AM, Ulrich Möller wrote:
> Am 02.07.2015 um 03:08 schrieb Neil:
>> 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
>
> Hi Neil,
>
> i would trust the IT department for their  backup/restoring process,
> because normally only the administrator will be able to restore a file
> or a folder. But has anyone considered the "Offline Feature" of a shared
> network location of the clients. Perhaps there exists a client which is
> not always attached to the network or has some trouble with the network
> connection and has enabled this feature. It could be possible that this
> client makes a resync on the mapped files when the connection is
> reestablished after an interruption.
>
> Just an idea...
>
> Ulrich

Hmm, I didn't know you could use a share offline. I'll pass this along 
to the client.

Thanks.

[toc] | [prev] | [next] | [standalone]

#10903

Could it be synching with DropBox or some other cloud based storage and an older version is overwriting the newer one on a regular basis? I had something like that happen once.

[toc] | [prev] | [standalone]

Back to top | Article view | comp.databases.ms-access

csiph-web