-
Patch Lady – Access gets beat up again
I was updating the master patch list tonight and spotted that there’s a new known issue listed on all of the Windows patches in regard to Access:
Last time it was Access 97 format, this time it’s Access 95 format. Apparently we keep old databases around for a long time.
It’s expected to be fixed in late February.
Applications that use a Microsoft Jet database with the Microsoft Access 95 file format may randomly stop working. Option 1: Convert the database to a newer .mdb file format. This doesn’t require a change to the Connection string. - Use Microsoft Access to open a database that has an older file format.
- You will be asked if you would like to convert. Click Yes and save the database with the .accdb file extension.
- Open the .accdb.
- From the File menu, click Save as and select Access 2002-2003 Database.
Option 2: Convert the database to the .accdb file format. To use the .accdb file format, you must change the Connection string after conversion.
The easiest way to convert is to use Microsoft Access 2010 or earlier.
- Use Microsoft Access to open a database that has an older file format.
- You will be asked if you would like to convert. Click Yes and save the database with the .accdb extension.
Microsoft is working on a resolution and estimates a solution will be available late February.