Unrecognized database format error 3343 (Need to Recover)

[pakarain]

Hi All,

I have a database Hotel-Indus.mdb, it becomes corrupted by fgui or someone else, anyone can recover it.



Regards,
Raheel Ahmed

[CJ_London]

once corrupted, it is unlikely it can be recovered. Recommend revert to a backup.

Hopefully you have split your database

Some things you can try first (but not much chance of success)

1. compact/repair
2. create a new db and import tables to your BE
3. create another new db and import everything else


if the import fails at some point (which it probably will), try importing one object at a time to identify which object(s) are causing the problem

[pakarain]

Many thanks for reply, I have done all suggestions like creating new db and import all objects, although at each level the error is there "Unrecognized database error", no one option is applying on this db.

[CJ_London]

OK, in that case you will need to revert to a backup

[isladogs]

Just one other thing to try...decompile your database to remove any corrupted compile code.
See Decompile and Compact Your Microsoft Access Database to Improve Performance and Fix Corruption (fmsinc.com)

[chris-smith]

Hi Raheel,



You can try applying the Registry Hack, i.e. disable the leasing on the server which is something that Microsoft also recommends to fix this error but it has some downsides like, you may experience some performance issues. You'll need Administrator priviliges to apply this registry hack.



To do this:

1. In windows search bar, type regedit to open the windows 'Registry Editor' app.

2. Navigate to the following path-

REG ADD HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\lanmanserver\parameters /v DisableLeasing /t REG_DWORD /d 1 /f

3. Execute the following commands-
NET STOP SERVER
NET START SERVER

4. Exit the Command Prompt.

Now check if you can open the database without any problems.
If this doesn't work, you can also try some other workarounds- https://community.spiceworks.com/how...e-format-error


Best Regards.