469,317 Members | 1,813 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,317 developers. It's quick & easy.

MS Jet database engine error message - help!

In Access'97, I am currently trying to run a Select query, which I
normally run every week, without problem, until now.

I am currently getting the following error message;

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

I'm not trying to change anything, nor do I believe that anyone else
is, or should be in my database.

Does anyone now what this means and how I can resolve it and continue
with my normal process?

Any help is much appreciated!

Thanks

Dec 5 '06 #1
2 1774
Delete the LDB file when there's no-one using the MDB file (including
you).

Dec 5 '06 #2
Thanks for this, but unfortunately, there's no *.ldb file (have shown
hidden file types etc).

I'm currently running my SQ again, taking each tbl & qry out one at a
time to see if I can pin-point the error.

However, when viewing each tbl behind my SQ individual they're ok, as
are the SQ's (there's two sub within the main one) when I run them
seperately.

Any more suggestions?

Many thanks.

Dec 6 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Russell Read [MSFT] | last post: by
7 posts views Thread by News | last post: by
2 posts views Thread by le0 | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by harlem98 | last post: by
1 post views Thread by Geralt96 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.