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.

    If that helped, take a second to support AskWoody on Patreon

    Home Forums Patch Lady – issues with Win10 Access 97

    This topic contains 8 replies, has 7 voices, and was last updated by

     deuxbits 2 months ago.

    • Author
      Posts
    • #309203 Reply

      Susan Bradley
      AskWoody MVP

      I just noticed that in the Windows 10 release notes it has this info: Remember this patching issue?  https://borncity.com/win/2019/01/11/windows-janua
      [See the full post at: Patch Lady – issues with Win10 Access 97]

      Susan Bradley Patch Lady

      6 users thanked author for this post.
    • #309264 Reply

      gborn
      AskWoody_MVP

      Susan, thanks for your post and your comment at borncity.com. I’ve added this comment with a remark. Will write another article, that will sum things up and point out some ‘pitfalls’ with the MS suggestions. Need some time (we have Saturday morning here in ‘old Europe’ ;-).

      1 user thanked author for this post.
    • #309341 Reply

      gborn
      AskWoody_MVP

      Well, here is the new article Microsoft confirms Access 97 MDB bug in Jet Database Engine caused by Windows January 2019 Updates with a few thoughts.

      3 users thanked author for this post.
    • #309348 Reply

      Seff
      AskWoody Plus

      I take it that we can follow the established principle that if we don’t know what Access 97 is then it doesn’t apply to us?

      • #310004 Reply

        deuxbits
        AskWoody Lounger

        Unfortunately no, you may need to be concerned about the issue. Many third party programs utilize the Microsoft lightweight database engine (Jet) that is associated with Microsoft Access. You may not have or use Microsoft Access directly but you may have a third party program that utilizes that underlying database engine and the older Access database file formats that it utilizes.

        Basic research is what I am doing when I don't know what I am doing - Werner Von Braun

    • #309376 Reply

      anonymous

      Does Linux run db4?

    • #309509 Reply

      johnf
      AskWoody Lounger

      Oracle Berkeley Database (DB4) runs on Android, Windows, Java and Unix (Linux). It seems to be used a lot for Crypto Currency (Bitcoin, foe example), although there are other industrial uses for it.

      As Elly said, you may want to ask the question about DB4/Linux in the Linux for Windows Wonks area, and see if anyone has experience with it. There’s also a lot of documentation on the Oracle Web Site, as well as here.

      • This reply was modified 2 months, 1 week ago by
         johnf.
    • #310003 Reply

      deuxbits
      AskWoody Lounger

      Although the MS note does not mention this, the bug also affects Access 95 format files as well. Furthermore, if the program attempts a compress/repair of these older format database files any tables containing field names longer than 32 characters will be deleted! This is otherwise know as data corruption.

      Basic research is what I am doing when I don't know what I am doing - Werner Von Braun

    Please follow the -Lounge Rules- no personal attacks, no swearing, and politics/religion are relegated to the Rants forum.

    Reply To: Patch Lady – issues with Win10 Access 97

    You can use BBCodes to format your content.
    Your account can't use Advanced BBCodes, they will be stripped before saving.

    Your information: