- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
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