[X]My Assistant

[Louverril]

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.

[GroverParkGeorge]

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.

[Corky]

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

[isladogs]

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

[Louverril]

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....

[GroverParkGeorge]

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.

[DanielPineault]

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.

[Louverril]

Thank you very much Daniel and George - I will keep checking.

[DanielPineault]

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?

[Louverril]

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

[Pleasure]

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