Thanks for the response Kevin.

The code you sent did not work because I am using MM6.0 yet (shame on me). I did add code to get the same result and if worked partially.

In your 2nd message you said:

>>When you call the LoadDataEnvironment() method, it calls ReleaseDataEnvironment(), which releases the current data environment. When the data environment is released, it calls CloseTables() from the Destroy() event. This should close the previous lookup table. I recommend tracing through to see if this is happening.

The LoadDataEnvironment() does call the ReleaseDataEnvironment()event but there is no call to CloseTables() or Destroy() events in the class. These events are not in the class. Is it because I am using MM6.0? These two events would take care of the problem, I think.

I do have MM6.1 (not loaded) but not MM6.1.2. Too many deadlines. Guess I need to get on the ball :).

Thanks for the help.

Bill