Access Database is getting corrupt again and again

We have an application which was working okay till last month. But after the last windows update our clients are getting issues with access database. access database got corrupted.  We ran compact and repair. But it still getting corrupted again and again.  This issue started right after the window update. clients are on different OS. Like server 2018, server 2012 and windows 10.

Is there anything i have check in new windows update or any other step to prevent database corruption?


 

Question Info


Last updated November 13, 2019 Views 27,124 Applies to:

* Please try a lower page number.

* Please enter only numbers.

* Please try a lower page number.

* Please enter only numbers.

The appears to be some issue as there have been several recent posts relating to sudden issues with databases that previously ran fine.

Since you believe it is a recent update that is causing the issue (and it' tend to agree) have you tried reverting your installation to a previously problem free build?

--
Daniel Pineault
Microsoft MVP 2010-2019

1 person was 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.

Can you enter the exact text of the error message you are seeing, and when you see it (e.g. do you see it when opening the database, when closing the database, or while using the database)?

Shane Groff

Access Engineering

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.

error 3343 unrecognized database format . Clients are getting it when they are using it. 

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.

Did you try rolling back recent updates?

Are all your users all running the same version of Access?  Which one?

Is your database properly split and each user given their own local copy of the front-end?

--
Daniel Pineault
Microsoft MVP 2010-2019

1 person was 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.

Its VB6 application and backend database as ms access. I tried rolling back update but not still its not working. 

Same Database and application is working okay since last 4-5 months. And as soon as client update his windows in 2-3 hours database is start getting corrupted. 

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.

is it possible to schedule a call? Its been issue with our 12 clients in 8 days.

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.

Can you try the workaround described here: https://support.microsoft.com/en-gb/help/2957623/cannot-access-shared-files-or-folders-on-a-drive-in-windows-server-201

To see if that makes the problem stop?

Shane

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.

Shane,

Do you know if that article also applies to more recent versions of Windows Server?

--
Daniel Pineault
Microsoft MVP 2010-2019

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.

Hey Daniel,

Not the update information, but we have had several customers report that the workaround (setting DisableLeasing in the registry) has resolved the problem for them.  This is a workaround, not a solution, but we know it is helping in the cases it has been tried.

Shane

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.

OK i will try this and update you. But does this workaround works for windows 10 and windows 7?  We have variety of client base who are having this issue.

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.