Failure to make a copy of table

  • Thread starter Thread starter ray
  • Start date Start date
R

ray

I tried to make a copy of table but received an error: The Microsoft Jet
database engine stopped the process because you and another user are
attempting to change the same data at the same time. It was ok and am at
loss what is wrong this time. Can someone advise the possible cause and
fix.

Thanks,

Ray
 
I tried to make a copy of table but received an error: The Microsoft Jet
database engine stopped the process because you and another user are
attempting to change the same data at the same time. It was ok and am at
loss what is wrong this time. Can someone advise the possible cause and
fix.

Thanks,

Ray
Click to expand...

How were you trying to copy the table? For that matter, WHY were you
trying to copy the table? Storing the same data redundantly in two
different tables is almost always a BAD idea.

If you really do want to copy a table (or part of a table), running a
MakeTable query is usually the best approach... but again this should
very rarely be necessary.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top