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

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

Lost all my changes...........

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

Contents

  Lost all my changes........... Neil <xxx@gmail.com> - 2015-07-20 07:35 -0500
    Re: Lost all my changes........... Patrick Finucane <patrickfinucanetx@gmail.com> - 2015-07-20 10:02 -0700
      Re: Lost all my changes........... Neil <xxx@gmail.com> - 2015-07-20 21:52 -0500
      Re: Lost all my changes........... Optimist <v.meldrew@i.do.not.believe.it> - 2015-07-22 21:43 +0100
        Re: Lost all my changes........... Neil <xxx@gmail.com> - 2015-07-22 17:21 -0500
    Re: Lost all my changes........... davewi11@yahoo.co.uk (Dave W) - 2015-07-20 18:59 +0000
      Re: Lost all my changes........... Neil <xxx@gmail.com> - 2015-07-20 21:57 -0500
    Re: Lost all my changes........... Neil <xxx@gmail.com> - 2015-07-21 08:51 -0500
      Re: Lost all my changes........... Peter <pxiberras@gmail.com> - 2015-07-21 12:30 -0700
        Re: Lost all my changes........... Neil <xxx@gmail.com> - 2015-07-22 02:27 -0500
      Re: Lost all my changes........... Peter <pxiberras@gmail.com> - 2015-07-21 12:30 -0700

#10941 — Lost all my changes...........

I just had one of the most bizarre things happen that I've ever had 
happen in the entire time I've been working with Access (~19 years). I 
am puzzled as to what's going on.

I was just working on a database, on one form in particular, and some 
global subroutines, for about 2 1/2 hours. During that time, I opened, 
closed, saved the form, and even backed up the database using File | 
Save and Publish | Backup Database. I use that backup method frequently 
while I'm working, and all the backups go into a separate Backup folder. 
While working on this database for 2 1/2 hours, I must've backed up at 
least 5-10 times. I also frequently saved my work by pressing Ctrl+S, or 
by clicking OK when I close a form and Access asks if I want to save it. 
(I press Ctrl+S so much while I'm working, I must've pressed it at least 
100 times during this 2 1/2 hour period.)

Also, I have a separate backup routine that runs every 6 hours and 
copies my work onto my external hard drive. This routine ran when I was 
about an hour into my work.

So, I finished the work, closed out of the database (again, saving 
everything) and took a break. I came back about 15 minutes later, and 
all my work was gone!!!! The state of the form I had been working on was 
the same state it was in after about the first 10 minutes of work 
tonight. Everything after that is gone. Just gone.

And I checked my Backup folder. There are no backups there from 7/20. 
The most recent backup was from 7/18! I know I did backups, and I got no 
error message when I did each one. But there are no backups from the 2 
1/2 hours I was working, though I know I did at least 5-10 backups.

So I have no idea what's going on. How could I have saved my work time 
after time after time, and done backups, and have them simply not be 
there??? This makes absolutely no sense to me.

I checked my backup copies to see if perhaps I was working on the wrong 
version, perhaps the version on my backup drive. But that one is also 
from the 18th. I also searched my C drive, to see if there was a stray 
copy of the file somewhere that I might've been accidentally working on, 
but didn't find anything.

One thing that was bizarre when I searched my C drive is that shortcuts 
to the file (in the Recent) folder show up in the File Manager search 
with the Access icon next to it. But the files themselves (the database 
file and the backup files with the date in the filename) show up with 
the INTERNET EXPLORER icon next to it!!

If I click on one of the backup copies of the database with the IE icon 
next to it, it opens fine.

But there are also about 6 copies of the actual database itself that 
have the IE icon next to it. When I click on one of those, the group of 
six all get selected. If I right-click and select properties, it shows 
the path and the filename as "file:///C:/Projects/mydb.accdb" (mydb 
isn't the actual name). When I double-click on it, the database opens 
fine (though the first time I did it it gave me the message, "This file 
could not be downloaded," and then opened the database).

How did my database get associated with Internet Explorer??? (And note: 
in the folder itself, it still shows Access 2010 as the associated 
program. But in the Search results, it's showing Internet Explorer as 
the associated program.)

After rebooting the computer and rerunning a search, it then correctly 
showed Access 2010 as the associated program.

So I have to wonder: was my system somehow erroneously saving my changes 
to the Internet (perhaps my OneDrive account), instead of to my hard 
drive? Sounds really bizarre, but it's the only thing that makes sense, 
especially given the Internet Explorer file association in the search 
results.

While I did close and reopen the database several times (when I did 
backups from within Access); and each time I reopened the database and 
the form my changes were still there; I never closed Access itself. It 
was only after I closed Access that I lost all my changes.

So I wonder if Access was storing all the changes in memory, or perhaps, 
somehow, in some Internet copy of my database, which it then lost when I 
closed Access? Sounds really bizarre, but it's the only thing that makes 
sense here. (Still can't explain why when I did backups from within 
Access those weren't written to the hard drive, especially since the 
correct folder appeared when did the Backup Database command.)

This is truly, truly bizarre. Anyone have any ideas as to what's going 
on and/or if there's any way to find the file I was working on?? :-((

Thanks!

[toc] | [next] | [standalone]

#10942

On Monday, July 20, 2015 at 8:35:55 AM UTC-4, Neil wrote:
> I just had one of the most bizarre things happen that I've ever had 
> happen in the entire time I've been working with Access (~19 years). I 
> am puzzled as to what's going on.
> 
> I was just working on a database, on one form in particular, and some 
> global subroutines, for about 2 1/2 hours. During that time, I opened, 
> closed, saved the form, and even backed up the database using File | 
> Save and Publish | Backup Database. I use that backup method frequently 
> while I'm working, and all the backups go into a separate Backup folder. 
> While working on this database for 2 1/2 hours, I must've backed up at 
> least 5-10 times. I also frequently saved my work by pressing Ctrl+S, or 
> by clicking OK when I close a form and Access asks if I want to save it. 
> (I press Ctrl+S so much while I'm working, I must've pressed it at least 
> 100 times during this 2 1/2 hour period.)
> 
> Also, I have a separate backup routine that runs every 6 hours and 
> copies my work onto my external hard drive. This routine ran when I was 
> about an hour into my work.
> 
> So, I finished the work, closed out of the database (again, saving 
> everything) and took a break. I came back about 15 minutes later, and 
> all my work was gone!!!! The state of the form I had been working on was 
> the same state it was in after about the first 10 minutes of work 
> tonight. Everything after that is gone. Just gone.
> 
> And I checked my Backup folder. There are no backups there from 7/20. 
> The most recent backup was from 7/18! I know I did backups, and I got no 
> error message when I did each one. But there are no backups from the 2 
> 1/2 hours I was working, though I know I did at least 5-10 backups.
> 
> So I have no idea what's going on. How could I have saved my work time 
> after time after time, and done backups, and have them simply not be 
> there??? This makes absolutely no sense to me.
> 
> I checked my backup copies to see if perhaps I was working on the wrong 
> version, perhaps the version on my backup drive. But that one is also 
> from the 18th. I also searched my C drive, to see if there was a stray 
> copy of the file somewhere that I might've been accidentally working on, 
> but didn't find anything.
> 
> One thing that was bizarre when I searched my C drive is that shortcuts 
> to the file (in the Recent) folder show up in the File Manager search 
> with the Access icon next to it. But the files themselves (the database 
> file and the backup files with the date in the filename) show up with 
> the INTERNET EXPLORER icon next to it!!
> 
> If I click on one of the backup copies of the database with the IE icon 
> next to it, it opens fine.
> 
> But there are also about 6 copies of the actual database itself that 
> have the IE icon next to it. When I click on one of those, the group of 
> six all get selected. If I right-click and select properties, it shows 
> the path and the filename as "file:///C:/Projects/mydb.accdb" (mydb 
> isn't the actual name). When I double-click on it, the database opens 
> fine (though the first time I did it it gave me the message, "This file 
> could not be downloaded," and then opened the database).
> 
> How did my database get associated with Internet Explorer??? (And note: 
> in the folder itself, it still shows Access 2010 as the associated 
> program. But in the Search results, it's showing Internet Explorer as 
> the associated program.)
> 
> After rebooting the computer and rerunning a search, it then correctly 
> showed Access 2010 as the associated program.
> 
> So I have to wonder: was my system somehow erroneously saving my changes 
> to the Internet (perhaps my OneDrive account), instead of to my hard 
> drive? Sounds really bizarre, but it's the only thing that makes sense, 
> especially given the Internet Explorer file association in the search 
> results.
> 
> While I did close and reopen the database several times (when I did 
> backups from within Access); and each time I reopened the database and 
> the form my changes were still there; I never closed Access itself. It 
> was only after I closed Access that I lost all my changes.
> 
> So I wonder if Access was storing all the changes in memory, or perhaps, 
> somehow, in some Internet copy of my database, which it then lost when I 
> closed Access? Sounds really bizarre, but it's the only thing that makes 
> sense here. (Still can't explain why when I did backups from within 
> Access those weren't written to the hard drive, especially since the 
> correct folder appeared when did the Backup Database command.)
> 
> This is truly, truly bizarre. Anyone have any ideas as to what's going 
> on and/or if there's any way to find the file I was working on?? :-((
> 
> Thanks!

Sorry to hear of your backup issue.  Have you looked in your Trash folder, perhaps you'll find them there.

Years ago I remember I did a tape backup.  It looked like it went and did the backup.  Then we needed to do a restore.  THe tape was blank, we had forgotten to click on a checkbox to allow the tape to be written to.  Arrrggs.

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

#10944

On 7/20/2015 12:02 PM, Patrick Finucane wrote:
> On Monday, July 20, 2015 at 8:35:55 AM UTC-4, Neil wrote:
>> I just had one of the most bizarre things happen that I've ever had
>> happen in the entire time I've been working with Access (~19 years). I
>> am puzzled as to what's going on.
>>
>> I was just working on a database, on one form in particular, and some
>> global subroutines, for about 2 1/2 hours. During that time, I opened,
>> closed, saved the form, and even backed up the database using File |
>> Save and Publish | Backup Database. I use that backup method frequently
>> while I'm working, and all the backups go into a separate Backup folder.
>> While working on this database for 2 1/2 hours, I must've backed up at
>> least 5-10 times. I also frequently saved my work by pressing Ctrl+S, or
>> by clicking OK when I close a form and Access asks if I want to save it.
>> (I press Ctrl+S so much while I'm working, I must've pressed it at least
>> 100 times during this 2 1/2 hour period.)
>>
>> Also, I have a separate backup routine that runs every 6 hours and
>> copies my work onto my external hard drive. This routine ran when I was
>> about an hour into my work.
>>
>> So, I finished the work, closed out of the database (again, saving
>> everything) and took a break. I came back about 15 minutes later, and
>> all my work was gone!!!! The state of the form I had been working on was
>> the same state it was in after about the first 10 minutes of work
>> tonight. Everything after that is gone. Just gone.
>>
>> And I checked my Backup folder. There are no backups there from 7/20.
>> The most recent backup was from 7/18! I know I did backups, and I got no
>> error message when I did each one. But there are no backups from the 2
>> 1/2 hours I was working, though I know I did at least 5-10 backups.
>>
>> So I have no idea what's going on. How could I have saved my work time
>> after time after time, and done backups, and have them simply not be
>> there??? This makes absolutely no sense to me.
>>
>> I checked my backup copies to see if perhaps I was working on the wrong
>> version, perhaps the version on my backup drive. But that one is also
>> from the 18th. I also searched my C drive, to see if there was a stray
>> copy of the file somewhere that I might've been accidentally working on,
>> but didn't find anything.
>>
>> One thing that was bizarre when I searched my C drive is that shortcuts
>> to the file (in the Recent) folder show up in the File Manager search
>> with the Access icon next to it. But the files themselves (the database
>> file and the backup files with the date in the filename) show up with
>> the INTERNET EXPLORER icon next to it!!
>>
>> If I click on one of the backup copies of the database with the IE icon
>> next to it, it opens fine.
>>
>> But there are also about 6 copies of the actual database itself that
>> have the IE icon next to it. When I click on one of those, the group of
>> six all get selected. If I right-click and select properties, it shows
>> the path and the filename as "file:///C:/Projects/mydb.accdb" (mydb
>> isn't the actual name). When I double-click on it, the database opens
>> fine (though the first time I did it it gave me the message, "This file
>> could not be downloaded," and then opened the database).
>>
>> How did my database get associated with Internet Explorer??? (And note:
>> in the folder itself, it still shows Access 2010 as the associated
>> program. But in the Search results, it's showing Internet Explorer as
>> the associated program.)
>>
>> After rebooting the computer and rerunning a search, it then correctly
>> showed Access 2010 as the associated program.
>>
>> So I have to wonder: was my system somehow erroneously saving my changes
>> to the Internet (perhaps my OneDrive account), instead of to my hard
>> drive? Sounds really bizarre, but it's the only thing that makes sense,
>> especially given the Internet Explorer file association in the search
>> results.
>>
>> While I did close and reopen the database several times (when I did
>> backups from within Access); and each time I reopened the database and
>> the form my changes were still there; I never closed Access itself. It
>> was only after I closed Access that I lost all my changes.
>>
>> So I wonder if Access was storing all the changes in memory, or perhaps,
>> somehow, in some Internet copy of my database, which it then lost when I
>> closed Access? Sounds really bizarre, but it's the only thing that makes
>> sense here. (Still can't explain why when I did backups from within
>> Access those weren't written to the hard drive, especially since the
>> correct folder appeared when did the Backup Database command.)
>>
>> This is truly, truly bizarre. Anyone have any ideas as to what's going
>> on and/or if there's any way to find the file I was working on?? :-((
>>
>> Thanks!
>
> Sorry to hear of your backup issue.  Have you looked in your Trash folder, perhaps you'll find them there.
>
> Years ago I remember I did a tape backup.  It looked like it went and did the backup.  Then we needed to do a restore.  THe tape was blank, we had forgotten to click on a checkbox to allow the tape to be written to.  Arrrggs.
>

Good idea about the Recycle Bin! Unfortunately, nothing there. :-(

The backup routine I have in place (which is just a batch file that uses 
xcopy) was working fine. The problem is that the backups created through 
the Access File menu were never created. As noted, I must've gone to 
File | Save and Publish | Backup Database at least 5 times during the 2 
1/2 hour session, and it seemed to work fine each time. Yet nothing was 
created!

So, the file wasn't saved when I pressed Ctrl+S or clicked OK when asked 
if I wanted to save changes before closing; AND no backups were created.

What could have caused this?? This is truly bizarre.

When you press Ctrl+S, get the hourglass, and then it goes away, you 
should have an assurance that your work is saved. And when you do Backup 
Database from the File menu, you should have an assurance that a backup 
copy of the database was being created. But neither was the case here. 
This is really bizarre.

The Internet thing I mentioned is the only thing that makes sense, as 
far-fetched as that might be.

Sadly,

Neil

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

#10950

On Mon, 20 Jul 2015 10:02:16 -0700 (PDT), Patrick Finucane <patrickfinucanetx@gmail.com> wrote:


>
>Years ago I remember I did a tape backup.  It looked like it went and did the backup.  Then we needed to do a restore.  THe tape was blank, we had forgotten to click on a checkbox to allow the tape to be written to.  Arrrggs.

Story I heard was of an office secretary who was instructed to make a copy of the floppy disk every
evening and store it in the fire-proof safe.  When the time came that they wanted to restore a file,
they looked in the safe and found photocopies of the floppy...

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

#10951

On 7/22/2015 3:43 PM, Optimist wrote:
> On Mon, 20 Jul 2015 10:02:16 -0700 (PDT), Patrick Finucane <patrickfinucanetx@gmail.com> wrote:
>
>
>>
>> Years ago I remember I did a tape backup.  It looked like it went and did the backup.  Then we needed to do a restore.  THe tape was blank, we had forgotten to click on a checkbox to allow the tape to be written to.  Arrrggs.
>
> Story I heard was of an office secretary who was instructed to make a copy of the floppy disk every
> evening and store it in the fire-proof safe.  When the time came that they wanted to restore a file,
> they looked in the safe and found photocopies of the floppy...
>
Well, at least the photocopies were safe and secure!

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

#10943

Neil <xxx@gmail.com> wrote:

>I just had one of the most bizarre things happen that I've ever had 
>happen in the entire time I've been working with Access (~19 years). I 
>am puzzled as to what's going on.

<story snipped>

>This is truly, truly bizarre. Anyone have any ideas as to what's going 
>on and/or if there's any way to find the file I was working on?? :-((

>Thanks!

You could do search for all files modified on that day, in case your
files got renamed and stored in a different folder.
-- 
Dave W

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

#10945

On 7/20/2015 1:59 PM, Dave W wrote:
> Neil <xxx@gmail.com> wrote:
>
>> I just had one of the most bizarre things happen that I've ever had
>> happen in the entire time I've been working with Access (~19 years). I
>> am puzzled as to what's going on.
>
> <story snipped>
>
>> This is truly, truly bizarre. Anyone have any ideas as to what's going
>> on and/or if there's any way to find the file I was working on?? :-((
>
>> Thanks!
>
> You could do search for all files modified on that day, in case your
> files got renamed and stored in a different folder.
>
I did do a search on all files that contain the base filename (to the 
left of the dot), in case it got something else appended to it. Doesn't 
seem it would've removed the base part. Guess I could also search for 
all ACCDB files modified today, just in case.

But, GAH, Windows 7 search is SO SLOW!!!!!!!!!!! Took like an hour to 
completely search my drive. (Running the same search on my other 
machine, which is XP, only took a few minutes.) Any ideas on how to do a 
search in Windows 7 without it taking forever?

Thanks.

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

#10946

On 7/20/2015 7:35 AM, Neil wrote:
> I just had one of the most bizarre things happen that I've ever had
> happen in the entire time I've been working with Access (~19 years). I
> am puzzled as to what's going on.
>
> I was just working on a database, on one form in particular, and some
> global subroutines, for about 2 1/2 hours. During that time, I opened,
> closed, saved the form, and even backed up the database using File |
> Save and Publish | Backup Database. I use that backup method frequently
> while I'm working, and all the backups go into a separate Backup folder.
> While working on this database for 2 1/2 hours, I must've backed up at
> least 5-10 times. I also frequently saved my work by pressing Ctrl+S, or
> by clicking OK when I close a form and Access asks if I want to save it.
> (I press Ctrl+S so much while I'm working, I must've pressed it at least
> 100 times during this 2 1/2 hour period.)
>
> Also, I have a separate backup routine that runs every 6 hours and
> copies my work onto my external hard drive. This routine ran when I was
> about an hour into my work.
>
> So, I finished the work, closed out of the database (again, saving
> everything) and took a break. I came back about 15 minutes later, and
> all my work was gone!!!! The state of the form I had been working on was
> the same state it was in after about the first 10 minutes of work
> tonight. Everything after that is gone. Just gone.
>
> And I checked my Backup folder. There are no backups there from 7/20.
> The most recent backup was from 7/18! I know I did backups, and I got no
> error message when I did each one. But there are no backups from the 2
> 1/2 hours I was working, though I know I did at least 5-10 backups.
>
> So I have no idea what's going on. How could I have saved my work time
> after time after time, and done backups, and have them simply not be
> there??? This makes absolutely no sense to me.
>
> I checked my backup copies to see if perhaps I was working on the wrong
> version, perhaps the version on my backup drive. But that one is also
> from the 18th. I also searched my C drive, to see if there was a stray
> copy of the file somewhere that I might've been accidentally working on,
> but didn't find anything.
>
> One thing that was bizarre when I searched my C drive is that shortcuts
> to the file (in the Recent) folder show up in the File Manager search
> with the Access icon next to it. But the files themselves (the database
> file and the backup files with the date in the filename) show up with
> the INTERNET EXPLORER icon next to it!!
>
> If I click on one of the backup copies of the database with the IE icon
> next to it, it opens fine.
>
> But there are also about 6 copies of the actual database itself that
> have the IE icon next to it. When I click on one of those, the group of
> six all get selected. If I right-click and select properties, it shows
> the path and the filename as "file:///C:/Projects/mydb.accdb" (mydb
> isn't the actual name). When I double-click on it, the database opens
> fine (though the first time I did it it gave me the message, "This file
> could not be downloaded," and then opened the database).
>
> How did my database get associated with Internet Explorer??? (And note:
> in the folder itself, it still shows Access 2010 as the associated
> program. But in the Search results, it's showing Internet Explorer as
> the associated program.)
>
> After rebooting the computer and rerunning a search, it then correctly
> showed Access 2010 as the associated program.
>
> So I have to wonder: was my system somehow erroneously saving my changes
> to the Internet (perhaps my OneDrive account), instead of to my hard
> drive? Sounds really bizarre, but it's the only thing that makes sense,
> especially given the Internet Explorer file association in the search
> results.
>
> While I did close and reopen the database several times (when I did
> backups from within Access); and each time I reopened the database and
> the form my changes were still there; I never closed Access itself. It
> was only after I closed Access that I lost all my changes.
>
> So I wonder if Access was storing all the changes in memory, or perhaps,
> somehow, in some Internet copy of my database, which it then lost when I
> closed Access? Sounds really bizarre, but it's the only thing that makes
> sense here. (Still can't explain why when I did backups from within
> Access those weren't written to the hard drive, especially since the
> correct folder appeared when did the Backup Database command.)
>
> This is truly, truly bizarre. Anyone have any ideas as to what's going
> on and/or if there's any way to find the file I was working on?? :-((
>
> Thanks!


UPDATE: I never did find the database. Seems the changes were just never 
saved (except somehow, weirdly, in memory only). Ended up redoing the 
work. (Only took me an hour to do redo the 2 1/2 hours worth of work, 
since I didn't have to work out the solution first.) So, all's well that 
ends well.

Still, weirdest frickin' thing I've ever seen in Access! Unbelievable!

And, yes, today I'm checking the work by completely closing out of 
Access and going back into it, and also making sure the file backups are 
actually being created. Everything seems back to normal. No idea what 
caused that thing yesterday.

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

#10947

Hi. Have you checked your machine for viruses. Viruses can mysteriously delete files and are also known for renaming file associations.

Peter

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

#10949

On 7/21/2015 2:30 PM, Peter wrote:
> Hi. Have you checked your machine for viruses. Viruses can mysteriously delete files and are also known for renaming file associations.
>
> Peter
>

Yes, viruses will do that. But this is a file I was using at the time, 
which kept all the changes, even after I closed and reopened it from 
within Access. But then, once I closed Access and went back into the 
file, all my changes were gone.

So I don't think it's a question of that the file was renamed after I 
closed out of Access (though I guess that's a possibility), but that the 
changes were never written to disk, but somehow were stored in memory.

Neil

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

#10948

Hi. Have you checked your machine for viruses. Viruses can mysteriously delete files and are also known for renaming file associations.

Peter

[toc] | [prev] | [standalone]

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

csiph-web