KB4480116 and KB4480970 failure getting access to MDB database ( Access 97 )

After installing in Windows 10 the KB4480116, our application ( developed in VS2010 with Microsoft Access 97 database MDB ) detects an error "unknown database format" when accessing to Access 97 database. The exception starts on msvc100.dll provided by VS 2010. Removing the KB4480116 the issue disappears. How I can get support for this accident ?

The same problem we have on Windows 7 after the KB4480970 installation of January 8th

I need help to solve this issue that stop working our end-user application.

 

Question Info


Last updated March 19, 2019 Views 4,218 Applies to:

* Please try a lower page number.

* Please enter only numbers.

* Please try a lower page number.

* Please enter only numbers.

After i replaced \windows\syswow\msrd3x40.dll (08.01.2019)

by an older version, the problem vanished.

13 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Hi karstenBock1,

many thanks for your suggestion.

We are doing so on both Win 10 and Win 7 successfully.

I hope that going back with Dll version, no other issues may appear elsewhere.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Thanks

Also working on Server 2016

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Hello.

KB4480970 stopped a lot of our plant around the world, with production loss.

How Microsoft thinks to fix this issue?

Tks,

Davide Gardoni

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Many thanks, it worked for me on W7 and W10

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

I had to change owner and permission to be able to replace the DLL.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

I can confirm this issue also.  After installing KB4480116 I get "Runtime Error 3343 Unrecognized database Format" when trying to access a MDB that contains our HR data.  The program is no longer supported so I cannot convert the database to a newer version.  Uninstalling the update fixes the issue and I am able to access the MDB.

I am religious about keeping updates current on all of our machines but this one for now is declined for install in WSUS.  Hopefully the issue is resolved in a future update, and a future cumulative update does not break this again.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

I can confirm it for the following Monthly Rollup:

  • KB4480970 (Monthly Rollup) january 8, 2019, Windows 7 Service Pack 1, Windows Server 2008 R2 Service Pack 1
  • KB4480963 (Monthly Rollup) january 8, 2019, Windows 8.1, Windows Server 2012 R2
  • KB4480966 (Monthly Rollup) january 8, 2019, (OS Build 17134.523) Windows 10, version 1803
  • KB4480116 (Monthly Rollup) january 8, 2019, (OS Build 17763.253) Windows 10, version 1809, Windows Server 2019, all versions

And after some trail and error we found out the problem, occurs with using JetEngine 3.6 (or higher?) to open an Acces97 database and the table contains a fieldname which has more than 32 characters. Tables which don't contain fieldnames with long names are still able to open.

Maybe there are some more situations, but this is what we found.

Using JetEngine 3.51 (the 'native' Access 97 driver) there doesn't seem to be any problems.

So 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"

Haven't tested it, but we tested the problem with DAO 3.51 and DAO 3.6 in ou software, and DAO 3.51 works, DAO 3.6 doesn't.

**Edit: I can confirm that OLEDB.3.51 resolves the problem of reading (but I don't if it might have problems generating a database, the code I have does have problems on adding an Index, but at other points it did have special 4.0 additions, so I need to check it further if I need to change stuff).

**Edit: mind you, for provider Microsoft.Jet.OLEDB.3.51 to work you'll need to have it installed, where 4.0 comes pre-installed with windows, 3.51 doesn't.

**Edit: Just tested the following provider and it seems to work like the Microsoft.Jet.OLEDB.4.0 provider (with the ACE version  could create an Acces97 mdb without any errors), :

"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=.\<MyAccessDatabase>.mdb;User Id=admin;Jet OLEDB:Database Password=<MyPassword>;Jet OLEDB:Engine Type=4"

....Sigh... OLDEDB.12 doesn't work anymore after AccessDatabaseEngine 2016 is installed, due to the provider being pointed to the DLL of Office 2016 which doesn't support Access97 anymore (thanx Microsoft for doing something stupid like that), only way to fix that, is manually change the link back to the original DLL.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Appears to be the same issue we are seeing in our software out in the field.  While we don't have individual column or table names with more than 32 characters, we have many queries that reference the column by tablename.columnname which results in more than 32 characters.  If we change the queries to reference the table name by a shorter alias the errors no longer occur.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Windows would not let me replace the file, said it had to be done by a trusted installer.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

So it affects all supported Windows versions after the January 8, 2019 security updates has been installed, because the Jet Database Engine patch breaks access to MS Access 97 databases. I've summed up at: Windows January 2019 Updates breaks access to Access DBs.

I will escalate this thread to other moderators - hopefully someone of the MS forum moderators will forward it to Microsoft's developers. 

Blogs: http://www.borncity.com/blog /(Ger) - and - http://borncity.com/win/ (EN)

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

* Please try a lower page number.

* Please enter only numbers.

* Please try a lower page number.

* Please enter only numbers.