Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Corrupt database - Please Help

Author  Topic 

tmdavis1
Starting Member

6 Posts

Posted - 2008-01-28 : 07:18:58
When trying to open my Access database I get the following error:

The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time.

When I spoke to the end user's, they stated that this problem began when one of the user.s PC was unplugged while she was still in the Access DB.

I have tried Access Compact and Repair, Jet Compiler, opening while holding down the shift keys, and creating a new DB and importing the data, and with each I have gotten the same error. Can anyone help me fix this database?

Any help would be greatly appreciated.


TMDavis

jhocutt
Constraint Violating Yak Guru

385 Posts

Posted - 2008-01-28 : 07:53:59
http://support.microsoft.com/kb/235391



"God does not play dice" -- Albert Einstein
"Not only does God play dice, but he sometimes throws them where they cannot be seen."
-- Stephen Hawking
Go to Top of Page

tmdavis1
Starting Member

6 Posts

Posted - 2008-01-28 : 14:06:38
I tried the jet35sp3, but got the same results. When I try to open or compact & repair I continue to get the same error message.

Any other ideas are greatly appreciated.


TMDavis
Go to Top of Page

dean_hogg
Starting Member

1 Post

Posted - 2008-03-26 : 07:52:30
This error message generally occurs due to possible corruption in memo field of your access database. This error can occur when you are at one form, open another form based on that same table as the previous form, make a change to the data and not refresh the original form, Or similar operations.

I will suggest you to try access repair utility to repair your database. Stellar Phoenix Access Recovery is very useful software to repair corrupted access database.

You can download the trial version from here : http://www.repair-access-file.com/access-mdb-recovery.php it will scan your data, and wil show you how much data is recoverable. If you are satisfied then purchase the full version and get your data back successfully.
Go to Top of Page

fyz
Starting Member

4 Posts

Posted - 2008-05-05 : 09:30:12
Hi,

There is a tool called Advanced Access Repair. I have used it to repair many corrupt Access MDB files on my damaged disks successfully. Its homepage is http://www.datanumen.com/aar/ Maybe you can also try this.

Alan


fyz
Go to Top of Page

natguy
Starting Member

2 Posts

Posted - 2008-05-30 : 03:50:45
This error may displayed when the long value column has bad data stored in it. The page in which the row is stored differs from the one in which the long value is stored. “Unrecognized database format” error in jet database engine may come when Jet Database Engine improperly shuts down while the process of writing down to the disk that cause corruption in jet database engine as well as database file. To repair this file you can use compact and repair utility or Stellar Phoenix access repair software which will scan your database and repair it.
You can get it here: [url]http://www.repair-access-file.com[/url]

Good luck
Go to Top of Page
   

- Advertisement -