To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=53438
------- Additional comments from [EMAIL PROTECTED] Tue Aug 23 00:23:03 -0700 2005 ------- > I can try to give a Step-by-Step but my macro has about 350 lines. Since you're working on Windows, I suppose there's another symptom of the problem: If your macro cannot overwrite the file because it's locked (in use), then most probably also actions like renaming the file (in the explorer) fail. Could you please try this. > I can try to give a Step-by-Step but my macro has about 350 lines. > First take a Calc-File and create a datasource. Register it! > Save the *.odb-File > When it's registered right, then make a new Writer-document. So far, so reproducible. > Insert a "field" command, a serial letter field with datas of the > datasource. Here it becomes fuzzy :). I did this, and did not have any problem with the .ods file. So I assume you're still doing something differently. Again I'd like to ask you to be as explicit as possible in your description. This is not to hassle you, it's because everybody has his own set of implicit assumptions, which he considers "natural", but which might be completely different from other people's assumptions (this also holds, for instance, for possible ways to "Insert a "field" command, a serial letter field with datas of the datasource.") So, as long as we don't have a common understanding of what you're doing to cause the problem, it can not be fixed. > but how should i know in my macro if a connection is established to a > datasource or not. And how can i close a connection? You cannot. Connections have a clear ownership, and if some other instance opened a connection to a database, your macro cannot decide that it should now close it, since your macro does not own this connection (or the process associated with the open connection). If - and I assume that this is the case here - some process opens a connection, but does not close it afterwards when it doesn't need it anymore, then this is a bug. However, if a connection is opened and needed, then you cannot simply close it, but ask the user - who triggered the action which opened the connection and still needs it - to cancel/finish the process. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]