Database Fizzled
Apr. 20th, 2016 11:31 pm![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
trickykittyAccess kept shutting down unexpectedly (after I was having issues with a single macro running), which prompts it to make a backup file automatically, and Google Drive is where everything is housed, but that keeps randomly giving "Cannot Connect" messages and going offline, even though the rest of my internet is pounding away just fine.
Between Google trying to keep up with the multiple copies uploading and Access continuously, unexpectedly closing, followed by Google giving up completely and deleting ALL the files, I've only managed to snag about 90% of the database I've been working on at work. That 90% is currently split into two different database files, one with corrupted VBA, but from what I can tell almost all the forms, tables, queries, etc. that I had as of the last save, and one with good VBA, but missing the forms and associated programming from the previous two days worth of work. At one point Google/Access gave me a file labelled "Backup of Backup of Backup of Backup of Invoices DB Backup Copy" I was on the verge of tears thinking the database would be completely gone at that point.
I blame the tug of war between the two giants while little ol' me sits in the middle of the carnage.
What I'm most angry about is that I had one of those random sparks of combined insight and energy and was able to accomplish in the past two days about as much as I'd gotten done the whole previous two weeks. So, the loss of a huge chunk of VBA programming, along with knowing I'll be spending the better part of tomorrow sewing these two files back together, has me irked to no end. Yes, there was a backup file already, but Google does Versions of files in spurts, which was why the previous versions I could find are missing the last couple days' worth of work. If only the VBA wasn't giving errors in the more complete file...
I think I'm going to start manually backing up this sucker to my hard drive as well, especially after making large amounts of changes.
Between Google trying to keep up with the multiple copies uploading and Access continuously, unexpectedly closing, followed by Google giving up completely and deleting ALL the files, I've only managed to snag about 90% of the database I've been working on at work. That 90% is currently split into two different database files, one with corrupted VBA, but from what I can tell almost all the forms, tables, queries, etc. that I had as of the last save, and one with good VBA, but missing the forms and associated programming from the previous two days worth of work. At one point Google/Access gave me a file labelled "Backup of Backup of Backup of Backup of Invoices DB Backup Copy" I was on the verge of tears thinking the database would be completely gone at that point.
I blame the tug of war between the two giants while little ol' me sits in the middle of the carnage.
What I'm most angry about is that I had one of those random sparks of combined insight and energy and was able to accomplish in the past two days about as much as I'd gotten done the whole previous two weeks. So, the loss of a huge chunk of VBA programming, along with knowing I'll be spending the better part of tomorrow sewing these two files back together, has me irked to no end. Yes, there was a backup file already, but Google does Versions of files in spurts, which was why the previous versions I could find are missing the last couple days' worth of work. If only the VBA wasn't giving errors in the more complete file...
I think I'm going to start manually backing up this sucker to my hard drive as well, especially after making large amounts of changes.
