none
Jan 2019 Update Problems

    Question

  • Since the Jan 2019 windows update, all of our customers are going down.

    We have an application that uses JET to an .MDB file and we keep getting connection errors.

    If we uninstall the update then then program works fine.

    In the other forum, they mentioned the change to msrd3x40.dll has caused the problem.

    Help... my entire customer base is going down, along with my credibility.

    Dave

    Friday, January 11, 2019 4:59 PM

All replies

  • Why don't you contact JET to let them know about your issue? I think JEt is also Microsoft partner.



    How old are you (just asking)?

    Saturday, January 12, 2019 12:52 AM
  • I guess he means: you are not old enough to know that JET was an ancient database access API from Microsoft.

    As he is someone still using it, he is probably older than 50.

    Saturday, January 12, 2019 5:11 AM
  • Hi,SPART123,

     

    Seems that it is a known issue in the KB articles of all Windows security patches. 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”. Microsoft is working on a resolution and estimates a solution will be available early February.

     

    You can use one of the following options as workaround:

    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.

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

     

    Before doing any changes, we always recommend to backup at first. Also we found some other workarounds that some guys mentioned using to fixed their issues, as below for your reference:

    1. Replace the msrd3x40.dll with an older version. You may need to change owner and permission to be able to replace the DLL. A successful example as below:

                    Folder: C:\Windows\SysWOW64 on 64 bit OS, C:\Windows\System32 on 32 bit OS

                    Bad: version:4.0.9801.7 date:09/01/2019 09:35

                    OK : version:4.0.9801.5 date:25/09/2018 02:56

    2. Change the string defining the used Data Source Provider.

                    If you're using a connectionstring like: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=<MyAccessDatabase>.mdb"

                    It might be solved using the following: "Provider=Microsoft.Jet.OLEDB.3.51;Data Source=<MyAccessDatabase>.mdb"

     

    You can also check following link for more details: https://borncity.com/win/2019/01/11/windows-january-2019-updates-breaks-access-to-access-dbs/

     

    Note: this is a 3rd party link, we don't have any warranties on this website. It's just for your convenience. If any other questions, please feel free to post back.

     

    Best regards,

    Zoe Mo


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Monday, January 14, 2019 9:22 AM
  • Hi SPART123,

     

    What is your current situation? Have you tried the suggestions provided above? Please remember to mark the replies as answers if they help, any other questions please feel free to post back. Thank you for choosing Microsoft.

     

    Best regards,
    Zoe Mo


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Wednesday, January 16, 2019 8:56 AM
  • Hi,

     

    We haven’t heard from you for a couple of days, have you solved the problem? Would you mind letting me know the update of the problem? Please remember to mark the replies as answers if they help, any other questions please feel free to post back. Thank you for choosing Microsoft.

     

    Best regards,
    Zoe Mo


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Friday, January 18, 2019 9:11 AM