I should have said this is running on an old SQL Server 2000 box. Will your solution still work?

I believe option 1 will work. I'll kick the tires.

Thank you.

It is hard to explain.

Imagine records like this

a b ...

Most of our stuff was converted to a COTS product, but we still have a few legacy apps that use Access as a front end.

I worked on these many years...

It was the &&**( shift key. All is good now.

Access is not my friend.

We are not using cmd shell. Rebooting stopped the process. Maybe the index defrag is hogging too many resources?

That is a good start. Still rather mysterious...

Thank you! Glad brilliant peoples still troll this website.

I installed the 64 bit native client for SQL2005. This did not solve the problem.

I ran the app on Windows 2008 32 bit and...

No I tried installed a 32 bit version of the SQl Client and 2008 R2 would not cooperate. I had to install the 64 bit version of the client.

Nope. The app we are using is ancient. What I really wanted was the native client for SQl2005 64 bit. I installed it. ...

Yes all we need is the MDAC.

I found a blurb from Microsoft saying Server 2000 is not supported on Windows server 2008 R2. This is not amusing.

Yes, we will need a DSN. The SQL200 database will be on a different box. We just need to connect to it.