cannot open a database created with an older version of the application

Gerry02 You can extract tables from an old .MDB database into Excel as long as they are under ~1,000,000 rows. It's a bit time-consuming (one table at a time), but you can load them all onto worksheets, save the Excel file and then import them to a new .accdb database, as follows:
1. Open Excel.
2. Select Data | Get Data | Legacy wizards | From Data Connection Wizard (Legacy)
3. In the Data Connection Wizard, select Other/Advanced and then Next
4. Select Microsoft Jet 4.0 OLE DB provider from the list of Providers, then Next
5. Browse and select the .mdb file. Leave the username as "Admin" and 'Blank password' ticked (checked), then Ok
6. The tables in the database should be displayed. Select one, then Next
7. No need to change anything in the 'Save Data Connection File and Finish' screen. Select Finish
8. In the Excel Import Data dialog, select where you want to put the data and click Ok
9. The table will be imported to Excel.
10. Repeat for all tables.