Patch Lady – keeping track of Access issues @ AskWoody

Patch Lady – keeping track of Access issues

Posted on February 6, 2019 at 22:56 CST by Susan Bradley • Comment in the Forums

A recent question of the forum reminded me that there was a recent post I saw about issues migrating to 1803 and it’s impact to Access databases. As I posted in the forum post the situation was as follows….

“Client has a database app written In MS Access. It imports data from an Excel spreadsheet using a macro. Reportedly, when the client O/S is 1803 the import corrupts his data and it needs to be repaired. Not so when the client O/S is 1709.”

To fix this, the person did:

Add the following Registry Values:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanWorkstation\Parameters]

“FileInfoCacheLifetime”=dword:00000000
“FileNotFoundCacheLifetime”=dword:00000000
“DirectoryCacheLifetime”=dword:0000

Sources for these reg edits below:

1803 UPDATE SERIOUS ISSUE

https://social.technet.microsoft.com/Forums/en-US/3cd934cc-cbc3-4bdc-8c29-8e486528ce9f/1803-update-serious-issue?forum=officesetupdeploylegacy

Microsoft Access Database Corruption

https://answers.microsoft.com/en-us/msoffice/forum/msoffice_access-mso_win10-mso_2016/microsoft-access-database-corruption/e933f760-f7f2-4b3e-9bc3-0061d5073219

Access – Bug – Database is in an Unrecognized Format

https://www.devhut.net/2018/06/13/access-bug-database-is-in-an-unrecognized-format/

Access reports that databases are in an ‘inconsistent state’

https://support.office.com/en-us/article/access-reports-that-databases-are-in-an-inconsistent-state-%ef%bb%bf-7ec975da-f7a9-4414-a306-d3a7c422dc1d?ui=en-US&rs=en-US&ad=US

Not this is not the same as the Access 97 bug that impacts all Windows platforms with data tables longer than 32 characters.

Windows Patches/Security Patch Lady Posts

Plus Membership

Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.

AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.

Welcome to our unique respite from the madness.

It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.

Patch Lady – keeping track of Access issues

Plus Membership

Search Newsletters

Search Forums

View the Forum

Search for Topics

Recent Topics

Recent blog posts

My Profile

Key Links

Patch Lady – keeping track of Access issues

Plus Membership

Search Newsletters

Search Forums

View the Forum

Search for Topics

Recent Topics

Recent blog posts

My Profile

Login and Registration

Key Links