Is there a way to automate the conversion of old Access databases (.MDB files) to the newer .ACCDB format?

Question

I have a couple hundred old Access databases, in the old .MDB file format. I'm not sure which version of Access they were created in. My ultimate goal is to make them usable to someone who has Access 2013. Access 2013 cannot open the .MDB files at all, but Access 2007 (which I have) can. Upon opening one in Access 2007, the "Database Enhancement" tool pops up and allows you to save the .MDB as an Access 2007 (.ACCDB) file, which Access 2013 can also open. I've done this successfully with a few of the .MDBs.My question is, is it possible to automate this process?I've looked around and as far as I know, the only way to convert an .MDB to an .ACCDB is the way I've done it, opening each file manually with Access 2007. Despite removing the capability to read .MDBs from the 2013 version, Microsoft has never put out a conversion utility or anything for people who may have data stuck in old .MDBs.

Answer 1

Hi, With the help of a VBA module, you would be able to create a loop through all of the .MDB files in a specified directory (or set of directories) and then save them as .ACCDB files automatically with no human intervention required.