Cut & Paste somtimes create deadlocks on SQL Server

[Kyle]

I have users that sometimes try to cut and paste multiple
rows of data from MS Excel to MS Access 97/XP. This
sometimes works, but certain forms have a proclivity
to "hang" in such a way that not only the local user is
impacted but all the SQL server users (at least for that
database). I cannot find any MS articale on the topic.
Can anyone explain what is happening and how to prevent
it? Tell users not to is not very effective.

 

[Rick Brandt]

I have users that sometimes try to cut and paste multiple
rows of data from MS Excel to MS Access 97/XP. This
sometimes works, but certain forms have a proclivity
to "hang" in such a way that not only the local user is
impacted but all the SQL server users (at least for that
database). I cannot find any MS articale on the topic.
Can anyone explain what is happening and how to prevent
it? Tell users not to is not very effective.

You most definitely should not allow this. I have seen cases where just
opening an ODBC link directly in Access has imposed a lock on that entire
table on the server (the user who did this then went to lunch).

Just provide them a Datasheet view form. it should still let them paste in
rows, but won't create the locking problem.