Database Corruption

[kitty77]

I've recently had database corruption rather frequently... So, I decided to split my database. But I'm still have corruption. Three times today.
I know many things can be a factor but can anyone steer me in the right direction as to a possible cause or solution or check?

Thanks...

 

[jdraw]

I suggest you tell us about your database; users; network etc. Three times in one day --any details would be helpful.
Also look at the Similar Threads below. You can also use google to search for MS Access corruption.

 

[theDBguy]

Hi. Just checking, which one is getting corrupted, the FE or the BE?

 

[kitty77]

BE

 

[zeroaccess]

And each user is running a copy of the FE from their own computer?

 

[theDBguy]

BE

If you're using Windows 10, what build number is it?

 

[kitty77]

And each user is running a copy of the FE from their own computer?

 

[kitty77]

Yes, each user is running a copy of FE on their own computer.

 

[zeroaccess]

Can you tell us about the corruption? Is data messed up? Or is the whole file unable to be opened?

 

[kitty77]

Windows 10 Pro for Workstations, ver 1903, build 18362.657 (BE)
Windows 10 Home, ver 1909, build 18363.657 (one of the computers that have the FE)

 

[kitty77]

Can you tell us about the corruption? Is data messed up? Or is the whole file unable to be opened?

 

[kitty77]

Whole BE can not be opened

 

[kitty77]

Looks like a possible solution is Disable Leasing? At least that's what I found on Google...

 

[theDBguy]

Windows 10 Pro for Workstations, ver 1903, build 18362.657 (BE)
Windows 10 Home, ver 1909, build 18363.657 (one of the computers that have the FE)

Okay, thanks. Maybe you are affected by this bug. If so, ask you IT dept to apply this fix.

Database is in an Inconsistent State or Unrecognized Format

There is a new bug with Microsoft Access reporting "Database is in an Unrecognized Format" or "Inconsistent State". Here is how you can fix the issue.

www.devhut.net

 

[theDBguy]

Looks like a possible solution is Disable Leasing? At least that's what I found on Google...

Hi. Yes, that's what I was suggesting too. Good luck!

 

[kitty77]

Does anyone know how that is done? Can seem to find good instructions...

 

[zeroaccess]

How about this?

https://www.reddit.com/r/sysadmin/comments/c052ot

 

[kitty77]

Not sure that helps me. Still unsure...

 

[zeroaccess]

Those are the specific instructions to disable leasing. If this is at work, talk to your network admin.

 

[theDBguy]

Does anyone know how that is done? Can seem to find good instructions...

Hi. Did you see the link I posted earlier about the fix to apply? It should have told you how to disable leasing, which is exactly what zeroaccess also posted.