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

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

Re: Database is "losing data"

Show all headers | View raw

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.

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