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

If your Access DB has attached SQL Server tables, you might look at your bit column definitions and their default values.  There is a known problem and Microsoft has posted a work-around.

I'm not able to even open the DB.

Can you give me the link

thanks

When deleting a record:
http://support.microsoft.com/?kbid=318882

Corrupt ver3 database
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q182/8/67.ASP&NoWebContent=1

General broken Access page:
http://msdn.microsoft.com/chats/office/Office_100302.asp

==============================
This might also have happened if one user opens the database with a different version of Access and causes the database to be converted to a later version.

In general, you should use the JetComp utility to repair and compact your Access database.  The JetComp utility is a free download from Microsoft (and elsewhere).

If this Access database is in a shared directory on a file server, you should also look at the open file shares on that server.  It is possible that the file server's file system thinks the .MDB file is still open.

When you try to open the db inside access, then the error message appears?
In the first place is it indeed true that another user is accessing the same mdb file?
That other user copy of the program might be locking the mdb file.

If not maybe an old lock file is lying around preventing you from opening the file.

It might also be a problem on the user level security set on the database.

Hmmmm. you said the file is big.
there is a possibility that the mdb file might have gotten corrupt and
Jet is having difficulty reading data in some tables. Can happen when Access
was improperly shutdown during a previous operation.
Make good backups of the mdb now.
Then have a copy available for experimenting and perform compact and repair
operation on that test copy and see if the error message will dissappear.

ok,
The DB is not that big is only 150 Mb, i have the jetcomp program downloaded but excuse me , i tried to use it and i cannot get it to work.

i have a copy to experiment that i copied on to my workstation  from the original one.

in the first line that says "database to compact from source:"
i click browse to the place where the db is.

then in the 2nd field i'm not sure on what to do, please tell how and i'll try.

remember that when i try to open the db that's when the error comes up. and doesn't allow me to do anything.

also there is no body connecting to it.

I Really need some help here i anyone can try to help me I would be very grateful, and also there is 500 points

the second field on jetcomp is for the name of the new database to create in the compact/repair process.

Create a New Database and import ALL the objects from the "stale" one into the new one...

ok,

i finally understood how to do the jetcomp thing, and guess what..

It didn't work, it says "error compactind DB"

i don't know what else to do, is like i'm stuck.

s.o.s

Have you tried importing all the objects into a NEW database container?

ok,
can you please tell on how to do that.

thanks

Create a new database
Import ALL the objects from your old database into the new one

Right click the white space on the database window and select IMPORT

walk thru the wizards and select EVERYTHING in the source database (presuming it may let you preview it...)

I tried but the same message still comes up.

What do say about the next step should be?

go to a backup?


regards,

klos81

having a backup in these times is a very good thing....

ok here since you have been with me after all, you are going to get the 500

thanks

Are we in good shape with the backup?... (always a good thing, backups!!)

and IF you have a good backup.... see if windows will let you delete (send to recycle) the old file.   This gives a hint at what is screwing up.