CODEWITHSUNDEEP
sql-server-2005ms-access
Phillip Senn
Phillip Senn

Reputation: 47625

Delete slow SQL Server table linked to Microsoft Access

I have a link from Microsoft Access to a SQL Server table. The I/O is pretty good except when I tell it to delete some 1400 records. It takes about 45 seconds to process through that. If I issue the same delete command in SSMS, it runs instantaneously.

Upvotes: 3

Views: 2203

Answers (1)

mwolfe02
mwolfe02

Reputation: 24227

Run it as a pass-through query

Upvotes: 5

Related Questions