Append Query Very Slow

[Alex]

I'm so frustrated. I have a very simple, yet large database (because of the
# of records). I have an append query that tries to append approx. 10,000
records to a table that contain anywhere from 10,000 - 50,000 records. It's
a very simple append query, no calculations, no join; just one table
appending records to another. I have a 3 field multiple primary key that
I've indexed using the Index dialog box. I've never indexed that way, but
I'm assuming in they show indexed in that box, they don't show indexed in the
fields' properties. I was wondering if the reason the query may be slow is
because of the multiple primary key. Any ideas of other reasons it may be so
slow? Is that a large number of records to append?

Thanks

 

[Jeff Boyce]

Alex

"Slow" is relative. If your vehicle took as long to stop as your append
query, would you be concerned?

When you append records, Access has to ensure that indexes are not violated,
and that each new record's index is properly recorded.

If you are 100% confident that the new records you are appending will NEVER
conflict with existing records on the index, consider removing the index,
adding the records, and re-indexing.

Good luck

Jeff Boyce
<Access MVP>