MDB file un-openable

james_sellwood · June 13th, 2003, 05:37 AM

I have an Access mdb file which cannot be opened. When it is double clicked on Access opens and then a pop-up error message appears (twice) stating that:

Quote:

quote:The Microsoft jet database engine stopped the process because you and another user are attempting to change the same data at the same time. (OK / Help)

I have looked online and this seems to be possibly caused by #error data within one of the database tables. I cannot get into the database to check the table and it's content. I found references to a utility called jetcomp.exe which is provided to compact and repair database files from outside of Access. When I run this and try to repair the database into a fresh blank one I get the error message

Quote:

quote:Error compacting database

Does anyone know how i might get into the database file. There are no other users trying to use it and other database files work fine on the same machine. This error occurs on all new copies made of the file no matter what machine they are tested on.

Thanks in advance for any help / ideas given. They would be useful.

--------------------
:) James Sellwood :)
--------------------

Steven · June 13th, 2003, 06:58 AM

Possibly changing the record locking options you have for Access might do something.

Have you tried importing the tables into a new mdb file?
If you can't link through Access, can you link through Excel, or some other program that can take ODBC?

If either of those work, you'll at least get your data.

HTH

Steven

There are 10 kinds of people in the world - those who understand binary - and those with friends

ciko1973 · June 13th, 2003, 07:05 AM

Hi,

If I understand ok,

u can try to see if your microsoft system have already opened a process "MSACCESS.EXE" (in Task Manager).
If you have another MSACCESS process, kill him and retry.

If now the file mdb is opened correctly, you must restar your system.

Kenny Alligood · June 14th, 2003, 07:56 AM

I would try going into the *.mdb that you created the *.mde from and complie all the code and make a new *.mde.

Kenny Alligood

james_sellwood · June 16th, 2003, 03:29 AM

There was no other process active. I am only using an mdb file (no mde file involved). I could not import the data into Access or Excel.

A colleage of mine found a utility which fixed the mdb file the way jetcomp was supposed to. I think it was called Recover Access. Unfortunately I did loose the forms within the mdb file, but all data and queries were recovered successfully.

Thanks for the advice.

--------------------
:) James Sellwood :)
--------------------