It's funny after taking the time to post in detail what I tried already I found a solution. I found out that the connection is lost only if opening...

Wow thanks Alan! If I explain how I am interpreting this can you confirm if I am correct?

First, a temp result set is created with all the rows of...

Yes the export date would be included in the query results, in fact all the data would be included. The oldest date would be preferred.

I wanted to add to this question an important piece of the puzzle. That is that the export date is part of the key. So what I am...

I had a chance to try to let the master files know that the database is moved, but things are complicated by the fact that the drives where the files...