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.
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 |
 |
|
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 |
 |
|
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. |
 |
|
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.Alanfyz |
 |
|
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 |
 |
|
|
|
|
|
|