That error usually means the database was created in a very old version of Access, most likely Access 2.0 from the early 90s. Even though the file extension is .mdb, not all MDB files are the same. Microsoft switched to the newer ACCDB format in Access 2007, but Access 2007 and 2010 still supported opening MDB files. Starting with Access 2013, support for the oldest MDB formats like Access 2.0 was removed. Access 2010 (32-bit) was the last version that could open and convert those old files. Once converted, you can open them in newer versions like Access 2021. If you don't have access to an older version, you may need to find someone who can do the conversion for you. Even I don't have a copy of Access 2010 installed anymore.

There are a few third-party tools and services that claim to convert old MDB files, but most of them either don't support Access 2.0 or are geared more toward data recovery than format conversion. One service that has a decent reputation is EverythingAccess.com, which offers paid conversions. You can also find tools like MDB Viewer Plus that work with newer MDB files (like Access 2000 - 2003), but they won't help with older ones. I have not used these services myself.

That said, ChatGPT tells me it has access to an Access 2010 virtual machine and might be able to try converting the file for you. If you're comfortable sharing the file, you can upload it there to see if it can get it converted to a format you can open. Again, I have not tried this myself.

Kim I have some older versions of access going back to 2003. If Chat GPT can't help you let me know I can see what I can do on some virtual machines I have.

Yeah, back when I actually used to do consulting work, I kept virtual machines active with every combination of Windows and Access. I think I stopped that back in 2019, but it was a pain getting older files from customers and having to convert stuff over. Now I just have the latest versions.

Kim, if Dave or Richard can help great, but if not, I just did a huge project for a client that had to convert from Access 2.0 (1993).  I have everything setup as you will need to convert it to Access 2003 and then Access 2007 and then to the latest version...  Let me know...  Thanks

Dave,
Thank you for the offer. I have one thing I am going to try, and if that does not work I may take you up on having you convert it for me.

Kim

John,

Thank you for your offer. I would like to try doing myself, however, I could use your help if I fail.

Kim

That's fine.  Unless you have Access 2003 installed, then you will run into the road blocks.  There really is no way around it...  I have never used these other conversion tools, but on one occasion and in that case it only converted the tables...

Hey Kim, Good Luck!! It's always better to learn by doing then to watch someone else do it! I actually want tot take one of my old databases and see what Chat GPT does with it lol.