To make sure we are on the same page, I have manually created a linked server named TEST. On the Security tab of the properties, I changed the option...

Ok, Yes, i have created a test link manually and only changed one thing at a time. I copied the exact .mdb from the new not working location to...

I think i might be confused by your questions, so please bear with me.. If I move the .mdb from the new location to another server (2000) that i know...

I can see and open the file that resides on my 2008 server from my sql 7 server. I have made sure the permissions on the folder is full...

Actually I am unable to run the Profiler while my production floor is up and running.  After about 5 minutes, the sql server starts to bog down and affect the...

I have been running the query looking at waittimes and they are all zeros, so I guess this not a concern although I do explicit close connections on each connection otherwise...

Not sure if I am providing the correct info but the last_batch indicates the spid has been open anywhere from a few seconds to 20 minutes, the cmd will be AWAITING...