News, tips, advice, support for Windows, Office, PCs & more. Tech help. No bull. We're community supported by donations from our Plus Members, and proud of it
Home icon Home icon Home icon Email icon RSS icon
  • Patch Lady – issues with Win10 Access 97

    Posted on January 11th, 2019 at 23:07 Susan Bradley Comment on the AskWoody Lounge

    I just noticed that in the Windows 10 release notes it has this info:

    I just noticed that in all of the Windows releases this month (Windows 7, 8.1, Windows 10, Server 2008 R2, Server 2012, Server 2012 R2, Server 2016, Server 2019) they have now listed a side effect with Access 97 based databases.

    Remember this patching issue?  https://borncity.com/win/2019/01/11/windows-january-2019-updates-breaks-access-to-access-dbs

    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”.

    Use one of the following options:

    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.

    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.

    Option 3: 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.

    Microsoft is working on a resolution and estimates a solution will be available early February.

    UPDATE: I have a tweet from Danial Beato Lopez that says the Napco Quickloader also has the same problem.