Failure to make a copy of table

[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

 

[John Vinson]

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

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