Append query taking almost hours (1 Viewer)

[sportsguy]

I have an append query from an SQL Server db to a local table, three fields, one key field in each, and 20,000 records takes about 30 minutes, with the database alternating between not responding and running every 5 seconds. . . . . my XP machine would have this done in less than 1 minute

my XP machine has a broken video card at the moment,

Windows 7 x64 Office 2007, ODBC SQL2008 8 G RAM, 200 G free disk space, high end Dell laptop, excel and outlook open as well. (doesn't affect performance as overnight download never finished as well.)

what am i missing?

is There a security setting in McAfee which is causing some sort of virus checking? is there a service which is stopped which would help?

thanks in advance. . .

sportsguy

 

[AccessMSSQL]

How are you connecting to the SQL Database? Are you connected over the network - are you logged into the Domain?



http://www.accessmssql.com/