Database hangs, and this problem appears

[shamal]

Hello everyone
Database where this error appeared and does not open!
Is there a way to solve this problem?
Ask me to help with that!

 

[CJ_London]

Would need to know more (is the app split? what is the back end? where is the app normally located? on a server? your machine? if server do you have a hardwired connection? ) however looks like the file is corrupted. From the size of the file it looks like it contains forms/code/etc plus tables so not split.

Suggest revert to a backup as I don't believe you can retrieve anything

Edit: I've tried opening your app from another db and also tried opening using ctrl-bypass and get the same error message.

 

[isladogs]

I can confirm getting the same error
This means one or both of the following:
1. Its a split database and the linked table location isn't correct
2. The database is corrupt

I have tried using the shift bypass and decompiling but neither helped. Nor did trying to import objects into a new database

EDIT: Too late as CJ_London has written almost exactly the same thing. I also think its probably unrecoverable

 

[shamal]

Would need to know more (is the app split? what is the back end? where is the app normally located? on a server? your machine? if server do you have a hardwired connection? ) however looks like the file is corrupted. From the size of the file it looks like it contains forms/code/etc plus tables so not split.

Suggest revert to a backup as I don't believe you can retrieve anything

Edit: I've tried opening your app from another db and also tried opening using ctrl-bypass and get the same error message.

Hello
A database that is not partitioned and located on a computer only

 

[shamal]

I can confirm getting the same error
This means one or both of the following:
1. Its a split database and the linked table location isn't correct
2. The database is corrupt

I have tried using the shift bypass and decompiling but neither helped. Nor did trying to import objects into a new database

EDIT: Too late as CJ_London has written almost exactly the same thing. I also think its probably unrecoverable

Hi
A database that is not partitioned and located on a computer only

 

[shamal]

Would need to know more (is the app split? what is the back end? where is the app normally located? on a server? your machine? if server do you have a hardwired connection? ) however looks like the file is corrupted. From the size of the file it looks like it contains forms/code/etc plus tables so not split.

Suggest revert to a backup as I don't believe you can retrieve anything

Edit: I've tried opening your app from another db and also tried opening using ctrl-bypass and get the same error message.

I tried to recover only two tables
I still have about fourteen tables not recovered

 

[isladogs]

OK so how did you manage to recover those two tables?

 

[The_Doc_Man]

When I tried to open it, I get the message. Definitely a corrupted file. I see no easy way to get into it, but I have an older version of Access so might not be able to do anything constructive anyway.

 

[gemma-the-husky]

I know it's a bit late for this, but you ought to split databases, and you ought to take regular safe copies of both the front and back ends in case of any catastrophic corruption. Also back up your work to alternative media in the event of a hard disk failure. I am sure many of us have lost work and files through being sufficiently careful with back ups.

 

[shamal]

OK so how did you manage to recover those two tables?

i am used this program " accessfixinstaller" and "AccessRepairToolboxInstall" and "recoverytoolboxforaccessinstall"

 

[isladogs]

I would caution against purchasing any programs of that type.
Most are a waste of money. In general, any recovery they can do, can be done for free in Access

Anyway, good luck. Hopefully you have a recent backup

 

[shamal]

I would caution against purchasing any programs of that type.
Most are a waste of money. In general, any recovery they can do, can be done for free in Access

Anyway, good luck. Hopefully you have a recent backup

Thank you, dear teacher.
There are free programs and I did not purchase the program.
Unfortunately, I do not have a recent backup and this is what makes me sad and there is very important data that I lost.

 

[isladogs]

Unfortunately its always events like this which lead to setting up a regular backup routine.
If you have no other option, then it may be worth your while testing a demo of professional recovery software.
Perhaps you'll find something that recovers enough data to be worth the purchase price....but I wouldn't be too optimistic.

Good luck anyway

 

[isladogs]

I've managed to partly recover your database using free recovery software that I've used in the past and it can now be opened
That has restored 3 tables and lots of queries though many do not have their original names.
The recovery process used didn't restore forms/reports/modules however with luck you can restore most of them from an old backup
The file is a lot smaller as most of your data wasn't recovered.

Perhaps you will recover more with commercial recovery software but there is no guarantee they will work on such a badly corrupted file.
Suggest you try demo versions before spending any money

 

[shamal]

I've managed to partly recover your database using free recovery software that I've used in the past and it can now be opened
That has restored 3 tables and lots of queries though many do not have their original names.
The recovery process used didn't restore forms/reports/modules however with luck you can restore most of them from an old backup
The file is a lot smaller as most of your data wasn't recovered.

Perhaps you will recover more with commercial recovery software but there is no guarantee they will work on such a badly corrupted file.
Suggest you try demo versions before spending any money

Thank you dear brother
I also just recovered these tables
But I need to restore other very important tables
I am not interested in retrieving queries or forms

 

[isladogs]

I tried with two different file recovery apps. Both recovered exactly the same tables.
I think you have to accept that the remaining tables are permanently lost

 

[shamal]

I tried with two different file recovery apps. Both recovered exactly the same tables.
I think you have to accept that the remaining tables are permanently lost

you are a great person
I am confident that someone can find the solution?
I hope not to be desperate

 

[isladogs]

Your only realistic hope is to pay for the services of professional data recovery specialists.
Doing so won't be cheap but if the data is that important, you should research the various options available.
This is a very reputable company Access Database Repair Service (everythingaccess.com)

 

[The_Doc_Man]

Suppose the database is stuck in a recovery state and you do not have additional backups to restore. In that case, you can restore the database using the following command: RESTORE DATABASE [earnings] WITH RECOVERY.

Since that is not a "normal" SQL verb it might be helpful to explain the context in which that command would be given. And if you read the thread carefully, you would recognize that RESTORE is a TSQL command or SQL Server command but our original poster (OP) is talking about a native and monolithic DB. Access's ACE engine does not support the RESTORE verb. (Yes, we all wish it did...)