Feb 21

Microsoft Access Version Comparison Matrix

microsoftboxes2013Microsoft Access debuted in 1992 and recently celebrated its 25th Anniversary! Over the decades, Microsoft Access evolved with a large number of enhancements, database formats, features both new and old. and discontinued features.

It’s hard to remember all the changes. Fortunately, we created a comparison matrix that shows the different Microsoft Access versions and changes. See when versions were released, their latest service packs, database formats, linked tables, field types, security features, Windows Operating Systems, and many other features both new and old.

Visit our page: Microsoft Access Version Features and Differences Comparison Matrix

feature-matrix

 

Feb 21

Total Access Statistics Updates for Access 2016, 2013, 2010, 2007, and 2003

New versions of Total Access Statistics are available for Microsoft Access 2016, 2013, 2010, 2007, and 2003.

Enhancements:statistics

  • 2016, 2013, 2010, 2007, and 2003 Versions:
  • Adjusted treatment of null values as missing values rather than zero
  • Updated digital signature for Runtime MDE (for MDB databases)
  • Enlarged the field selection forms

For more information, visit:

Existing Total Access Statistics owners were notified to download the update.

Feb 07

Missing FBI Text Messages: Sean Hannity Radio Show

Introductionsean-hannity-radio

FMS President Luke Chung was invited on the Sean Hannity Show to discuss the technology behind text messages: how they work and how they are archived.

Below is the transcript from the interview followed by some comments on the story and how to avoid problems with data backup and disaster recovery.

Backgroundfbilogosmall

The FBI claimed to lose backups of text messages between FBI agent Peter Strzok and FBI lawyer Lisa Page between December 14, 2016 and May 17, 2017.

Radio Show

On January 22, 2018, Luke Chung was on the radio show with Sean Hannity and Andrew Ziem. The three of them discussed the technology behind the ability to retrieve text messages that were deleted. Luke commented specifically on:

  • How text messages are stored on a sender’s/receiver’s device, unlike emails which are stored on a central server.
  • The ability to retrieve an email that has been deleted is more likely than trying to retrieve a text.

Here’s the audio from the show:

Luke’s segment starts at the 3:28 mark to about 5:18. The discussion wraps up around the 7:12 mark.

Sean Hannity [0:01 – 2:34]: The bigger story today… how do we retrieve five months’ worth of text? Andrew Ziem’s the founder and lead developer of BleachBit. Luke Chung is the president of FMS inc and both are well-versed in the retrieval in the forensics of getting information back that is quote “been deleted”. Thank you both for being with us. Andrew Ziem it sounds like maybe a little bit of BleachBit was used here. Is that possible to use on an electronic device?

Andrew Ziem: BleachBit itself isn’t compatible with a mobile device but there are tools that are similar to that. And even regardless of using that tool, just the fact that so many months have gone by, I know it’s been it’s been well over half a year since May 2017. Even just using the device on a daily basis is going to slowly erase text messages by overriding the data.

Sean Hannity: Well I want to, Luke Chung we’ve talked to you many many times before. Why is it this very critical five-month period they’re missing all those texts? Considering you know this is the crucial period of time. Does that sound like an accident to you? It doesn’t to me.

Luke Chung [3:28]: Well thank you very much for having me back on-again Sean. The technology here is different from emails. Emails are stored in a central server and are much more permanent. Text messages are on the sender’s device. They go to a Telecom company, which then forwards to the recipient’s [Telecom company and] device. Usually, the Telecom throws it away soon after they make that connection. So, there’s no permanent centralized storage with text messages.

Sean Hannity: So, if they subpoena the Telecom company it will probably be a waste of time.

Luke Chung [3:55]: Right, because they have no reason to store billions of text messages. Once you get it on your phone, why would they ever need to hold it for you? It’s not like an email.

Sean Hannity: So, how, what are they usually saved for? Three days in rotation?

Luke Chung [4:05]:
It is usually saved to the extent that they send a message through. So, for instance, if the recipient’s phone is off, the text message isn’t lost. You know, Verizon or AT&T or whoever is holding on to that message waiting until it can send it through. And once you connect, it gives you the message. Some services may provide a way to deal with text messages on their website so you don’t even need a phone. So that would depend on what those people are doing.

Sean Hannity: But the likelihood that the Telecom company has all those are negligible, you’re saying.

Luke Chung [4:33]: I would presume so, because there’s no reason why they would want to keep it. Once they send it through, why would they? mean it’s just a waste of space for them.

Sean Hannity: What about forensically the phone itself or the device itself?

Luke Chung [04:45]: Correct, so the phones, the sender’s phone and the recipient’s phone would have those messages to the extent that they don’t delete them.

Sean Hannity: Okay, if they delete them?

Luke Chung [4:52]: If they delete them, then they would/could be on the little hard disk, for as mentioned before, they would probably overwritten over time.

Sean Hannity: And over time means that probably long gone considering the time period that were talking about is 12/14/16 to May 2017.

Luke Chung [5:07]: Right. I mean they probably have different phones.

Sean Hannity: What about we keep hearing from Bill Binney and others that every text every email that we send is metadata stored in places like Salt Lake City. Is that possible?

Luke Chung [5:18]: Well you can ask the NSA what they store, I would not know what they store.

Sean Hannity: Alright, Andrew what if they erased it on their phone but they have the phone. Would it be retrievable?

Andrew Ziem: Yes, step one would be trying to get access to both of those phones. Making sure we’ve got the password or whatever to unlock the phone. While it is still not super likely that every single message is there. It’s possible and likely if they didn’t intentionally wipe them clean with something like BleachBit, it’s possible that some of the messages are there. So, I think it’s definitely worth a shot to do forensic analysis on the phones.

Sean Hannity: Well, they had to get all the other text messages and then they… As soon as the special counsel was appointed on May 17th. Boom. They find the text again. It literally was gone in this crucial… it sounds like Watergate and what was it, the missing 18 minutes of erase tape.

Andrew Ziem: It’s super fishy.

Sean Hannity: It’s super fishy. What about emails? Is it the same, Luke? With email servers like you use Gmail, or MSN, or AOL, whatever. I mean do those emails get saved by those providers?

Luke Chung [6:12]: Emails get saved by those providers because they are running a server type solution. You can get your email from multiple devices, so it’s not [just] stored on the individual device. It is stored centrally.

Sean Hannity: And how long do they keep them for?

Luke Chung [6:23]: Well, they can keep them, I mean if you don’t delete an email message, they’ll keep them forever. Often times, even if you delete a message like Gmail, they would still store it and have it available in the [trash folder]…

Sean Hannity: They store it in perpetuity?

Luke Chung [6:36]: That’s the agreement that you make with Google. What they do with it is kind of their business.

Sean Hannity: So, the answer is we don’t know if they’d be able to retrieve an email.

Luke Chung [6:44]: Right. An email would be much more likely to be retrievable, because you can go to the server and get it. There’s no such thing as a text message server.

Sean Hannity: But considering it’s the five critical months in question here. That these that the text messages are missing and then they just mysteriously reappeared the day after the special counsel’s appointed. Do any of you, does that pass the smell test for any of you ’cause it doesn’t for me.

Andrew Ziem: It’s hard to explain another way Sean.

Sean Hannity: In other words, it was an 18-minute Gap in the Watergate tapes. It doesn’t meet the smell test that they weren’t erased on purpose, does it?

Luke [7:12]: I mean I would need, you know, I don’t have the data to be able to look at that. I guess they’re two parts of this. One would be to see who owns those phones. Are those FBI phones and were similar things happening to other FBI phones at the time or was it specific to these two people’s phones, right?

Sean Hannity: Yeah, it’s unbelievable. Alright, I want to thank you both. Andrew, thank you. Luke, thank you. Good to talk to you again.


Follow Up Notes

The FBI disclosed that the text backups they were making depended on software installed on each smartphone which encountered problems as the app and smartphone operating systems were updated. The backups were lost for a large number of FBI devices, and not just these two individuals.

Later, the FBI were able to recover the messages.

Lessons Learned

Data backup is critical to most organizations and may be required by law. Unfortunately, people don’t realize system administration tasks like data backup and disaster recovery aren’t working until they need it. Backups may seem like they are successfully running for weeks, months and years without someone verifying everything is working.

Failures could be intentional, but it’s usually a process breakdown or human error. Sometimes, it’s a budget driven issue since old backups (tapes, hard disks, etc.) get reused and older backups get overwritten.

We recommend:

  • Defining an acceptable data retention policy
  • Designing the processes to implement it
  • Budgeting the resources to support it
  • Testing the scenarios to validate the processes are working

Keep in mind there’s a difference between data backup/recovery versus business continuity and disaster recovery. See or paper on Creating a Backup and Disaster Recovery Plan for Microsoft Access Database Applications for some ideas.

Additional Resources