[Solved] Using Programming to disconnect a data source

[mbeamer]

I was wondering if anyone knows of a way to program a macro to disconnect a data source.

The reason I ask is that I am currently running a separate application which exports the data for a merge in a text file. The problem is that there are multiple times a day that a merge needs to be run, however after the first time the data file is accessed by OO it is locked until the data source is disconnected.

I appreciate any help.

[floris v]

The oooforum gave this result: http://www.oooforum.org/forum/viewtopic.phtml?t=10399

connection.close() does the trick.