Jet Database Error Message

[Guest]

When I edit a query in a database that's been working up until now, I get the
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"
There is no other copy of the database open and no-one else working on it so
am a bit confused.

Any ideas as to why this is happening would be great.

Alan

 

[Arvin Meyer]

You will often see this error when you have 2 forms (could be a form and a
subform) looking at the same record, or even a different record on the same
page. The "other user" mentioned is you.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Your original message states that you are trying to "edit a query" when you
get the Jet complaint. Sounds like it's not an issue with multiple users
against some data table, but more like having the query either (a) in design
mode while still in use by some other process or (b) maybe the query has been
opened twice in design mode. Is your database "split"? Is your system being
executed at the same time as others are trying to use it (are you on a
network)? For research, open your database, go directly to the query in
question and open it in design mode, make some simple change, and click the
SAVE icon (the little computer disk) on the toolbar to see if it saves
correctly.

Steve in Ohio