472,111 Members | 2,040 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,111 software developers and data experts.

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 1855
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
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.