"Copying in Progress" error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When attempting to copy records from a table or query using the ctrl-c
command access periodically freezes. I can see the "Copying in progress" msg
in the bottum left corner of the screen but it seems to freeze on this. This
error seems to occur more often once the table or query has been previously
filtered. Any ideas? I am not sure whether it may be my system or something
regarding Access that is causing this and can be changed/adjusted. Thank you
in advance for any assistance.
 
Copying, pasting or deleting a large number of records through the GUI
requires significant system resources. You may not be waiting long enough
for the operation to finish. It's much faster to copy records from one table
to another using a query. For example:

INSERT INTO tblArchive
SELECT *
FROM tblOrders
WHERE (tblOrders.OrderDate < DateAdd("yyyy", -1, Date()));

This query copies records that are more than a year old from tblOrders and
saves them in tblArchive -- just about instantaneously if I have an index on
the OrderDate column.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.
 
Back
Top