We maintain hundreds of Access databases on our LAN. We are moving to Office 2013 and I need to determine in which version of Access each database was saved. Access 2010 and 2013 apparently cannot open all versions of mdb file, so I need to know which ones I need to convert. Does anyone have the code for me to determine in which version each mdb and accdb is saved? Ideally, I need to run the code from one database that will loop through all the filed on the LAN (including subfolders) and save the file name, path, and version to a table. The link below contains another solution that loops through and tells me if a certain file type is linked to the databases. If the version could be collected during this process, that would be great.
Solution to determine if DBF files are linked