Copying and Pasting in XP - Unbelievably Slow

D

DeutchBose

In converting several databases to XP, I'm noticing that
if I try to copy data from large tables and/or queries,
it's absurdly slow.

This only happens with Tables/Queries from ODBC Data
Sources...it doesn't matter which Data Source I use,
they're all equally slow. The tables/queries load
normally, but copying takes a long time.

This does not happen with Access 97 on an NT platform.
Has anyone experienced this? Any ideas?
 
J

John Vinson

In converting several databases to XP, I'm noticing that
if I try to copy data from large tables and/or queries,
it's absurdly slow.

This only happens with Tables/Queries from ODBC Data
Sources...it doesn't matter which Data Source I use,
they're all equally slow. The tables/queries load
normally, but copying takes a long time.

This does not happen with Access 97 on an NT platform.
Has anyone experienced this? Any ideas?
Click to expand...

Do Append queries (a *much* better way to do this for many reasons!)
suffer the same problem?
 
Top