• Patch Lady – issues with Win10 Access 97

    Posted on January 11, 2019 at 23:07 CST by • Comment in the Forums

    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.

    Windows Patches/Security ,
DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    April 2025
    S M T W T F S
     12345
    6789101112
    13141516171819
    20212223242526
    27282930  

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.