Hanging My Head In Shame…

…or it could be banging my head on the desk. Right now, the two look very similar. After nearly 14 hours of non-stop data entry and tweaking what I thought I’d had in place before I lost everything with the Windows update, I had managed to get to a point where I thought I had nearly every base entry recovered. I did realize that there was a chance that my previous database wasn’t pulling my DNF numbers out of my overall books read count, so I couldn’t tell for certain what all I was missing. I had lost a lot of the smaller genre tags that I’ve created for my books and any notes I’d made, but I mostly had any new books added, give or take a few. I’d somehow lost some of my reread and DNF numbers, but for the most part I’d felt pretty good at what I’d been able to recreate.

I went to shut down the app and saw that it was somehow STILL tied to that Onedrive folder and I did not want that. I go to hunt down how to break that tie and see the folder has 4 instances of my database. All with different names and versions. Guess which version was in there? Guess what I learned about the search feature in Microsoft? It doesn’t search the Onedrive folder. Guess who was livid to have wasted nearly 14 hours of work? I was nearly in tears for the second time.

Yes, I’m thrilled to death I found my original database. I haven’t lost anything (that I can see so far), so that is a massive positive. I’m still pissed as hell because that version in the Onedrive folder had a different name entirely from the database I was using. The database I was using didn’t actually exist on my hard drive anymore because it had been replaced by that older version. This is something that should never, ever happen. Even if this had been an Office update rather than a Windows update, it should have never happened. Those files never should have been touched in any way, shape or form.

I’ve moved my active database to a different folder, hoping to prevent something like this happening again. It is in the same location I keep my photos as that is on an auto backup for my external drive, so hopefully that will mitigate any future problems.

I’m trying really hard to be grateful that I didn’t actually end up losing anything and going with the “lesson learned” mindset, but it is hard to do after the work I put into trying to fix it all. Yes, I probably (REALLY) should have found that Onedrive folder before I went to all that effort, but I had no clue that it didn’t show in search results when looking for files. I never even considered that would be the case. I do appreciate this process has pointed out a potential error in my numbers and forced me to remember my database needs to be backed up on a regular basis. None of that changes how pissed off I am at the whole damn mess.

I also need to go through all my Goodreads entries again, because I could have sworn my numbers were a little higher in my database before I lost it, so I still think the version I got was at least a few days behind, if not a couple of weeks. That means that even though I’ve recovered my data, I’m still not done having to go through it all and trying to find problems. *sigh* I just want to sit down and read!!

 

Feel Like Crying and Screaming – Technical Difficulties

I have lost a year and a half of book data from my personal database. I went to enter my latest read and something looked off when I opened the app. When I realized my dashboard didn’t have all of my latest changes I was really confused. Then I went to look at the latest entry and it was from early in March 2018.

How could I have somehow reverted to an extremely old version of said database you ask? Why Microsoft, of course! My computer demanded I update my version of Windows the other day or I would no longer be on a supported version. Multiple hours later and me giving up to get sleep instead, I log in and everything seems to have upgraded with no problem. Until I opened MS Access.

Apparently, the idiots missed a glitch that pulled information from their useless Onedrive folder (which I had disconnected from almost immediately after testing it out as it was glitchy as all hell and only useful for my grocery list, so I’m still baffled at the version I got), and OVERWROTE the database stored on my computer. You do NOT code upgrade software that at anytime EVER overwrites personal data files on a computer!!! Dipshits in QA need to have some conversations with my Hubby to learn how that shit is supposed to be tested.

I was absolutely devastated. I have been keeping track of my books for YEARS in this database. Constantly making tweaks and changes to make it better, easier to use and pull the kinds of information I’m looking for. I do also keep track of my books on Goodreads, thank goodness, but I keep so much more information in my database that I can’t keep track of in Goodreads (personal notes and where I reviewed it for example) and is why I kept using it after I found Goodreads. It doesn’t help one tiny bit that I’m a bit of a flake sometimes and forget to enter a book in both locations. Yes, I can probably recreate what I’ve lost, but it is going to take me hours if not days and I’m most likely not going to be able to get it all.

I’d also made some significant changes in the last year. New reports and summaries I was keeping track of. All of it is gone. I could absolutely kick my own ass about the whole thing as well because I JUST got a new external hard drive to back up all my important stuff, like my photos, and somehow I managed to overlook backing up my database, otherwise I would have only lost maybe a week or two of books. Believe me, I have dug and searched all through my computer and my version no longer exists in any form.

I’ve slept on my grief over the loss and I’m still infuriated and frustrated, but the only thing I can do is whatever I can to rebuild it. I’m trying to see the positive side of this in that I didn’t get a version that was years older than the one I got, but it’s incredibly hard to see any loss as positive. I’ll be getting my review  written and posted, but then I’ll be buried in my Goodreads and Amazon records working to get it all back. I can only hope it doesn’t piss me off any more than I already am or my computer may grow wings and fly out the window. Whether that window will be open first remains to be seen.