Forum Discussion
Problem with the MsJet40.dll released with the Windows 10 KB4566782 Update
> Basically, what Karl is asking...
No, Daniel, I really would like to know what I was asking for. The point is to determine if this is more an Access problem or a Windows problem.
Sorry Karl,
Truly didn't mean to step on your toes or insinuate not answering your questions for a single moment, it was more to encourage people to send information/feedback to Microsoft and share their issues and relevant information.
- PatrickLee2195Sep 12, 2020Copper ContributorMy problem has been solved by msjet40.dll Version 4.0.9801.27.
Thanks to Access Dev. Team - Dan2000Sep 10, 2020Copper Contributor
Problem Solved
Thanks to Microsoft Teams
- Tomy41Sep 09, 2020Copper Contributor
@alle
Gute Nachrichten 🙂
Mit dem aktuellen Update (KB4571756) wird die msjet40.dll auf Version 4.0.9801.27 aktualisiert.
Diese scheint nun wieder korrekt zu funktionieren, auf unseren Testsystemen können replizierte Datenbanken geöffnet werden.
- Sep 03, 2020
Hi,
Sorry, but I'm not aware of any public announcement in this matter so far.
You can have a look at the reply a poster gave in this thread on Sep 2 and hope he's right.
Karl
*********
http://AccessDevCon.com
Access FAQ (German/Italian): http://donkarl.com - PatrickLee2195Sep 02, 2020Copper Contributor
Due to the MSJET40.dll 4.0.9801.25 still is fixing, I would like to suggest that Access Dev Team takes out MSJET40.dll 4.0.9801.25 and puts back MSJET40.dll 4.0.9801.24 in both KB4566782 Update and
KB4565351 update (may be more KBxxxxxxx) until the issue has been fixed. - OChristiaanseSep 01, 2020Copper ContributorAny progress?
I'm amazed that the update still has a line like "we don't know of any problems with this update".
Might be applicable to the update process on it own, but the content has issues. - PatrickLee2195Aug 27, 2020Copper ContributorHi Karl,
I pretty sure and definitely that the problem is related Windows 10 because the problem occurred since Windows automatic updated by KB4565351, At the same time the MSJET40.dll is updated to version 4.0.9801.25, afterward we could not open my Accesss program, we needed to rollback to MSJET40.dll 4.0.9801.24 then to be back to normal working.
For My Case:
I am using Access 2000. One frontend MDB including many forms, report and queries to connect a backend MDB which is as database including all db tables. No others and it is so simple.
Problem with MSJET40.dll 4.0.9801.25 :
I just clicked the frontend MDB, it will show below error message:
"Unable to open database 'MSysAccessObjects'. It may not be a database that your application recognizes, or the file may be damaged "
I know i am using a old Access 2000, but the problem absolutely is related to Windows updated then cause this bug and issue.
I am grateful for Access Dev. Team helping to fix the bug. - Aug 26, 2020
Hi,
Another attempt to make my point clear which is not about the known fact that you can't open the replicated MDB files:
Did you do the replication by code from outside of Access (by programming it from wherever) or did you always and only work with the MDBs from within Access?
If we get several reports about this aspect, it would make the difference between an Access application problem in very old and unsupported versions but at least Access or a Windows problem that by accident affects MDB files. This distinction may not be easy to understand but it makes a difference in some respect (and I've tried my best until exhaustion ;-).
- Dan2000Aug 26, 2020Copper Contributor
As I wrote, I just double clic on the file, and msaccess.exe can't open the mdb entire file anymore, since it contains replicated tabes on it
Accessing data from outside does not work too
Is there anyone working with msaccess team here, so I can send him a mdb file to open ?
- Aug 26, 2020
Hi,
It's not that simple that just someone "has to correct his bug". We are talking about versions and features of (maybe) Access that are many years out of any support and the JET dll is part of Windows not of Access in the first place. So I would like to ask about your use case again:
Point 3 is clear as you mentioned Access 2000. But how about 1+2? Mind, there is a difference between opening up an MDB one time with Access to control it or really working with fully fledged Access applications and experiencing the problem.
1) Is it that you or your users open Access to manage replicated data in an Access frontend with forms, queries etc. and it is there where they experience the replication related problem, i.e. they cant't open their Access application with Access any more?
Or
2) Is it that you just use MDB files to hold data and pilote the MDB files and replication (i.e. msjt40.dll and msjro.dll) from outside of Access like with a VB or .NET etc. application? So there is no real Access application involved, just MDB files.
- Dan2000Aug 26, 2020Copper Contributor
Microsoft told me to write here , and here they are telling me to write to microsoft !
This is very simple. The developper who changed the msjet40.dll code from version .24 to .25 need to correct his bug
This dll is the msjet database engine used by msaccess mdb and is automatically updated by Windows update
The bug is very simple to reproduce, when you double clik on a MDB database file that is replicated, then msaccess can't open it anymore
I personnaly still open mdb database with msaccess 2000 exe, but I think it is the same with all msaccess versions, or openning the database by code