Your company's ad could live here and reach over 50,000 people a month!

Share This Post

Windows 10

Customers Still Using Access 97 Databases Affected by Windows 10 Patch Tuesday Updates

Customers Still Using Access 97 Databases Affected by Windows 10 Patch Tuesday Updates

As we noted last week, KB4480966 for Windows 10 1803 Causing Unrecognized Database Format Error.

Applications that use a Microsoft Jet database with the Microsoft Access 97 file format may fail to open if the database has column names greater than 32 characters. The database will fail to open with the error, “Unrecognized Database Format”.

However, its now recognized that this issue affects Windows 10 1803, 1709, and 1703 and boils down to customers still utilizing old Access 97 databases. Obviously, Microsoft didn’t intend for this to happen and customers surely didn’t expect to still be using such old technology for database operations. However, for those customers that are experiencing problems, Microsoft is working on a solution. In the interim, the company has delivered the following workarounds…

Option 1: Modify the database to ensure that all column names are less than or equal to 32 characters.

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.

  1. Use Microsoft Access to open a database that has an older file format.
  2. You will be asked if you would like to convert. Click Yes and save the database with the .accdb extension.

Option 3: Convert the database to a newer .mdb file format. This doesn’t require a change to the Connection string.

  1. Use Microsoft Access to open a database that has an older file format.
  2. You will be asked if you would like to convert. Click Yes and save the database with the .accdb file extension.
  3. Open the .accdb.
  4. From the File menu, click Save as and select Access 2002-2003 Database.

Share This Post

Leave a Reply