Q: HELP!! Can't run append query!

  • Thread starter Thread starter Mark D
  • Start date Start date
M

Mark D

Using Access 2000:

I'm trying to run an append query and am getting the
error "The microsoft jet database engine stopped the
process because you and another user are attempting to
change the data at the same time"

But,
1) I'm the only user in the database
2) I have the database opened exclusively
3) the table I'm appending to is native to that database

So, what would be causing this error?

THANKS!
 
Hi Doug, thanks for your reply.

Unfortunately, that's not it. I restarted the computer and
opened the database (after compacting many times) and ran
the query without opening anything else.

Still the same problem.

?????
-Mark
 
Okay, figured it out.

the table I was appending to was native, but the table I
was appending from was linked to another access database.

I compacted *that* database and the append worked.

-Mark
 
Back
Top