We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

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

klos81
klos81 asked
on
Medium Priority
12,175 Views
Last Modified: 2008-07-04
I'm getting this message when I try to open the DB, it is access 2000 the database is a little big.

Can anyone please help me there is very important data in it, but keep in mind I'm not much of a Db person i'm more like networks, but i'm the only one here that has a little bit of db knowledge.

Thanks in advance.
Comment
Watch Question

aikimarkSocial distance; Wear a mask; Don't touch your face; Wash your hands for 20 seconds
CERTIFIED EXPERT
Top Expert 2014

Commented:
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.

Author

Commented:
I'm not able to even open the DB.

Can you give me the link

thanks
aikimarkSocial distance; Wear a mask; Don't touch your face; Wash your hands for 20 seconds
CERTIFIED EXPERT
Top Expert 2014

Commented:
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.
rqs

Commented:
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.



rqs

Commented:
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.


MS Access Systems Creator
CERTIFIED EXPERT
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
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.


Author

Commented:
I Really need some help here i anyone can try to help me I would be very grateful, and also there is 500 points
jadedataMS Access Systems Creator
CERTIFIED EXPERT

Commented:
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...

Author

Commented:
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
jadedataMS Access Systems Creator
CERTIFIED EXPERT

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

Author

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

thanks
jadedataMS Access Systems Creator
CERTIFIED EXPERT

Commented:
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...)

Author

Commented:
I tried but the same message still comes up.

What do say about the next step should be?

go to a backup?


regards,

klos81
jadedataMS Access Systems Creator
CERTIFIED EXPERT

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

Author

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

thanks

jadedataMS Access Systems Creator
CERTIFIED EXPERT

Commented:
Are we in good shape with the backup?... (always a good thing, backups!!)
jadedataMS Access Systems Creator
CERTIFIED EXPERT

Commented:
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.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.