Created attachment 1468 [details]
Spreadsheet to use as data source

Created attachment 1469 [details]
Dummy form letter to demonstrate fault - must connect addresses.sxc as 'test' data source

Error dialog from OO gives:

Object not accessible
The object cannot be accessed due to insufficient user rights

and from W2K:

There has been a sharing violation: the source or destination file may
be in use.

Greg, can you please check if connection pooling is enabled?
(Tools/Options/Data Sources/Connections)

By default, this is enabled, and it means that connections to data
sources are held some time after they have been released by the
application. In case of a spreadsheet, this could mean that the
"database connection" as well as the "database table" (which is the
spreadsheet file) is not released, yet.

A second suspicious point in your description is this "until reboot".
Can you please confirm that you do not have the quickstarter active?
The quickstarter (the small butterfly icon in the system tray) keeps
OOo alive - with all consequences, as if you had a document open.
If you do _not_ have the quickstarter active, and the problem
persists, this is a even more serious issue. But for the moment,
sorry, I assume that it _is_ active in your scenario.

One more thing I'd like to ask: Please try to be more concrete in bug
descriptions. The idea of a step-by-step description may sound stupid
for such "simple" cases, but please believe me, it isn't! It simply
helps reproducing problems, and ensures that no implicit assumptions
are made which only the submitter knows. Only a bug which can be
reproduced can be fixed.
So I kindly ask you to give us a more detailed description. Something
like "start staroffice, create a new Spreadsheet data source with the
document attached, do ....".
In this special case here, this "data source for a form letter" is way
too unspecific. How exactly did you use it? Just setting it as data
source of the document? Merging data from this table? Inserting fields
from this table?
Please be gossipy :)

After giving us this information, please assign the bug back to me
(fs@openoffice.org).

Thanks
Frank

Created attachment 1484 [details]
Screenshot of W2K Task Manager

Created attachment 1485 [details]
Screenshot of OO Options/Memory

Hi Frank, thanks for your comments. Here's my response(s):

1)    Yes, connection pooling is enabled - but 60 seconds should see
the connection released - yes?

2)    No, quickstarter is not loaded (see OptionsOOOMemory.jpg)

3)    Here's the concrete (just don't make it into galoshes for me)!

i)    Open formletter.sxw

ii)   Use Tools/Data Sources/New data source to connect address.sxc as
source 'test'.

iii)  Use File / Form Letter, select Output / File radio button, click OK.

iv)   Close all OO windows

v)    Just go and peek at W2K Task Manager - what's this? See
taskman.jpg. Why is there an soffice.exe? Note that this wasn't done
before filing the issue first time.

vi)   Wait 60 seconds :-) as per response 1) above.

vii)  Attempt to rename / etc. from outside OO, file is locked.

Is that better?

greg,

(
can you please translate "just don't make it into galoshes for me" for
a non-native english spaker? :)
)

thanks for the descriptions. Because of the above sentence I'm not
sure if you felt offended by my request for information - if so, this
was surely not intended :)

As I see it, we have two problems: OOo not terminating when closing
the last window (people requested this as feature, but I do not think
that this is what they meant :), and the connection not beeing freed
when closing the form letter document.
About the former, I have no idea, but will try to reproduce, for the
latter, I'll try to reproduce, too, and the assign to
os@openoffice.org, as he's responsible for form letter ....

Hi Frank...

'galoshes' are over-boots, thus my reference is to being thrown into
deep water with concrete boots. I have an odd sense of humour, so
don't be upset if you don't get it?!

soffice only stays resident if I do the mailmerge thing (as previously
described!), and if killed of course the file lock dies with it.
Opening & closing further documents, soffice shuts down 'properly'
i.e. disappears from task list.

Cheers
Greg  |;^)

Hi Greg,

I do not have any problem with odd humor, I just did not recognize it
as humor :). np.

this sounds as if staying resident is a follow-up of not freeing the
connection (or at least of doing the form letter thingie). Strange ....

Frank

Fixed in a current release after srx643C. May be before :-)

closing

change subcomponent to 'none'