Access Database is getting corrupt again and again

Anonymous
2018-06-01T17:47:41+00:00

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?

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

604 answers

Sort by: Oldest
  1. Anonymous
    2021-01-15T20:12:24+00:00

    Good question - I'll bring it up in my upcoming DD meeting.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2021-01-15T20:31:33+00:00

    SQL express conversion is extremely expensive for complex DBs and provides a substantial performance reduction.

    Class action lawsuit... Attorneys

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2021-01-15T20:38:07+00:00

    While i understand what you are trying to convey, i wholeheartedly disagree.  My job, amongst many other things, is to advise clients when they are taking actions that risks their data.  This is one such case.  As long as you advise them of the risk, then they can't blame you or the product.  There are any number of way to maintain remote databases that doesn't risk the data, so being told to do something doesn't mean one follows blindly.

    And if, you truly have no other option than to run an Access database via VPN then I urge you to have a bulletproof backup system in place that make multiple backups throughout the day.

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2021-01-15T21:11:40+00:00

    "SQL express conversion is extremely expensive for complex DBs and provides a substantial performance reduction."

    That is a valid observation. 

    It all depends on the database.  The main issue is that often, applications (using an Access backend) aren't designed for client-server usage, as is the case of you start off with the intent of using SQL Server from the start.  So, yes, the conversion and further optimization can be time consuming, therefore costly, depending on the complexity of the application being converted.

    That said you do gain on reliability, security, ...

    Was this answer helpful?

    0 comments No comments
  5. Anonymous
    2021-01-15T21:55:02+00:00

    I wish it were that simple, Daniel. In large corporations, there are levels of management you have to present your suggestions to & they approve. If they don't approve, you don't move forward, and you have to come up with other options. Also a key question from mgmt is usually "What's the ROI on this idea ?". If they don't like your answer, again you don't move forward.

    Saying you won't use their VPN to log in because Access doesn't work well with VPN's is not an acceptable position. You have to work within your company/corporate environment, whether large or small. And as you know, some environments are quite political, so it's not just about your preferred technical option.

    Was this answer helpful?

    0 comments No comments