Avatar

Level 10

Yes that is correct ...so as th elast statement in your code add the command:

xfa.sourceSet.DataConnection.close();

This shoudl close the connection and free the lock after you have completed your retrieval of information. certainly that is how it works on "real" databases and thats what i expect in Excel but you will have to try it and see.

Paul