My Assistant
![]()
Custom Search
|
![]() ![]() |
![]() |
![]() Post#1 | |
Posts: 508 Joined: 29-April 08 ![]() | Two of my customers are suddenly getting "Unrecognised Database Error" messages. These on 2 systems that were fine before (one was a slightly changed version - but only very very minor - just some text on a form). I suspect some change in windows setup ?? Or could it be an anti virus system interfering - one of the customers suspects this? I have checked and running the exact same front end accdb file on my own system work's fine. Also (in the case of the one with the very slightly altered version) running the older version against their own live data still works - so I don't think it is as simple as corruption. Has anybody had any problems recently with windows updates or with anti virus programs? Many thanks. |
![]() Post#2 | |
![]() UA Admin Posts: 36,177 Joined: 20-June 02 From: Newcastle, WA ![]() | Yes, this is possible. See this article. Does it apply to YOUR problem perhaps? This post has been edited by GroverParkGeorge: Jul 10 2018, 03:01 PM Reason for edit: oopsie. |
![]() Post#3 | |
Posts: 359 Joined: 22-August 02 From: NE PA ![]() | The last (3) weeks I have had (5) client calls about getting the 'Unrecognized Database..." error. In the previous (17) years I have only had (2) client calls with this error. Somewhat troubling but in all cases the database was only marked as corrupt and running compact repair on the BE database corrected the issue with no data lose. I suspect that a recent windows update is messing with some network drivers or settings. Our clients all use split Access applications, FE installed on the users PC and BE database on a server. I had found that when clients first began using Windows 10 some client setups needed to utilize a UNC path vs mapped drive to the BE data as the clients using mapped drives were being randomly disconnected. In these instances though they never experienced the 'Unrecognized Database..." error, they just had to close the application and then open it again. Maybe it was just timing with doing a write to the BE but I suspect that these recent errors are the result of yet another update, OS revision. I had looked into the Mapped drive disconnect error and found that there is a registry setting that can have the OS recreate the mapped drives vs refresh them periodically during a work session. If the the registry is set to recreate them, MS Access, the 'Canary in Coalmine' disconnects each time? This paralleled the issue that the Windows 10 mapped drive users were experiencing, disconnecting ever 15+- minutes or so I was told. The recent errors are are on client systems that are also using mapped drive to the BE database vs a UNC path. I don't know if this is any help... Cork Shunk CS-Graphx |
![]() Post#4 | |
![]() UtterAccess VIP Posts: 1,883 Joined: 4-June 18 From: Somerset, UK ![]() | The problem also reappeared after the Windows 10 version 1803 update See also this article by Daniel Pineault : https://www.devhut.net/2018/06/13/access-bu...ognized-format/ The article also gives links for two workrounds |
![]() Post#5 | |
Posts: 508 Joined: 29-April 08 ![]() | Wow! Many many thanks for your help. At least I have an idea of why its happening. Do you know how to find out when it is fixed? Daft question maybe but just realised I don't know how to do this.... |
![]() Post#6 | |
![]() UA Admin Posts: 36,177 Joined: 20-June 02 From: Newcastle, WA ![]() | Check the references linked for suggestions on how to implement work-arounds. Check back at the Microsoft sites for updates. We watch these things here, but the "official" status is at MS sites. |
![]() Post#7 | |
![]() UtterAccess VIP Posts: 7,000 Joined: 30-June 11 ![]() | It's been over a month and we are still waiting to hear anything official from Microsoft on the subject. Your guess is as good as mine as to when we might see an official fix. |
![]() Post#8 | |
Posts: 508 Joined: 29-April 08 ![]() | Thank you very much Daniel and George - I will keep checking. |
![]() Post#9 | |
![]() UtterAccess VIP Posts: 7,000 Joined: 30-June 11 ![]() | According to what I've been told, they (Microsoft) believe the issue originated with a flawed Windows update (not office update, so it isn't specifically related to build 1803) and believe that it has since been resolved by a later July Windows update. (notice the frequent use of the word believe!) So according to this updating Windows should resolve the issue? |
![]() Post#10 | |
Posts: 508 Joined: 29-April 08 ![]() | Thank you very much for letting me know Daniel! ![]() That makes sense. I haven't heard any complaints lately since the most problematic customers network support were informed. So I presume they have been making sure that Windows is up to date. I can't be any more proactive with that customer - strange set up. But I will be doing an audit in a couple of weeks so I will find out the exact situation. The other customer has a better network support and they have had a lot of access database updates from me too - and for them definitely no further issues since around the 11th July |
![]() Post#11 | |
![]() Posts: 264 Joined: 1-July 05 From: Greece ![]() | More than a year now and still at "workaround" status See bellow: https://support.office.com/en-us/article/ac...US&fromAR=1 There is also a second workaround, that works perfectly and only needs to ... add some registry values at the Client Machines, leaving this way, the whole server without any changes ... See this 2nd workaraound here: https://github.com/MicrosoftDocs/windows-it...docs/issues/934 Also a good review of the whole problem can be found here: https://answers.microsoft.com/en-us/msoffic...3ad0031d?page=1 This post has been edited by Pleasure: Jul 29 2019, 12:10 PM -------------------- Dum spiro spero ... |
![]()
Custom Search
|
![]() | Search Top Lo-Fi | 9th December 2019 - 03:34 PM |