Access2Base DoCmd.Quit() leaves LibreOffice in memory

Discussions about using 3rd party extension with OpenOffice.org

Access2Base DoCmd.Quit() leaves LibreOffice in memory

Postby echo8hink » Wed Mar 02, 2016 8:18 pm

I have been using Access2Base in my macros to open and close forms. I recently discovered the "Quit()" action and have used it on a Main Menu form in LibreOffice Base. I use the option: Const acQuitPrompt = 0, and it appropriately gives the message box to save before exit and appears to work. However, when I check in the Windows task manager, there are two entries where it shows LibreOffice still in memory.

I am wondering if I missed cleaning something up before using the action of if it's something else. I have removed the action because those memory remnants seem to make LibreOffice unstable and increase the chances of it locking up in mid-app after using it.

-Dave
LibreOffice 5.4.5.1 on Linux Mint 18.3
echo8hink
 
Posts: 10
Joined: Wed Mar 02, 2016 7:59 pm

Re: Access2Base DoCmd.Quit() leaves LibreOffice in memory

Postby Villeroy » Wed Mar 02, 2016 11:01 pm

Disable the "quick-starter".
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27098
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Access2Base DoCmd.Quit() leaves LibreOffice in memory

Postby echo8hink » Thu Mar 03, 2016 3:41 am

The Tools->Options->Memory LibreOffice Quickstarter is not enabled. Would it have anything to do with the DBClose() macro recommended call in Tools->Customize->Events?
LibreOffice 5.4.5.1 on Linux Mint 18.3
echo8hink
 
Posts: 10
Joined: Wed Mar 02, 2016 7:59 pm

Re: Access2Base DoCmd.Quit() leaves LibreOffice in memory

Postby JPL » Thu Mar 03, 2016 1:50 pm

Could you please try
Code: Select all   Expand viewCollapse view
RunCommand("Quit")

and report us the result ?

Thanks in advance.
JPL
Windows 7 / LibO 6.0 / AOO 4.1
Ubuntu 18.04 / LibO 6.1
Access2Base extension (AOO) or standard (LibO).
BaseDocumenter extension (LibO)
Documentation on http://www.access2base.com and http://www.access2base.com/basedocumenter
JPL
Volunteer
 
Posts: 103
Joined: Fri Mar 30, 2012 3:14 pm

Re: Access2Base DoCmd.Quit() leaves LibreOffice in memory

Postby echo8hink » Thu Mar 03, 2016 9:36 pm

I replaced the Quit(acQuitPrompt) with RunCommand("Quit") and it cleanly quits with no remnant of LO in memory (Yeah!) when I check with Windows Task Manager. However, when I open the database file it insists on recovering. I also tried closing the form first with mClose() and then quitting and got the same results. I am beginning to think a MsgBox telling the user to "Ctl-Q" may be the best option. It's so easy.

Would it make a difference if the macro was in "My Macros" and not in the .odb file? I may try that...
LibreOffice 5.4.5.1 on Linux Mint 18.3
echo8hink
 
Posts: 10
Joined: Wed Mar 02, 2016 7:59 pm

Re: Access2Base DoCmd.Quit() leaves LibreOffice in memory

Postby RoryOF » Thu Mar 03, 2016 9:39 pm

Try a delay between the close command and the exit LibreOffice command, to give time for the close to work.
Apache OpenOffice 4.1.6 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29438
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Access2Base DoCmd.Quit() leaves LibreOffice in memory

Postby echo8hink » Thu Mar 03, 2016 10:08 pm

Tried "Wait 2000". Clearly enough time to see form close and go away. Now LO doesn't close?
LibreOffice 5.4.5.1 on Linux Mint 18.3
echo8hink
 
Posts: 10
Joined: Wed Mar 02, 2016 7:59 pm

Re: Access2Base DoCmd.Quit() leaves LibreOffice in memory

Postby Villeroy » Fri Mar 04, 2016 12:56 am

Leave the application up and running. I don't know what the problem is but it could be a problem that you try to let a Basic program shut down its own environment.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27098
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Access2Base DoCmd.Quit() leaves LibreOffice in memory

Postby echo8hink » Fri Mar 04, 2016 2:54 am

I think, for now, I am going to leave it at closing the main menu switchboard form and then letting the user close the Office interface by whatever means is comfortable or usual for them. I thought I had found a way to use a macro action to simplify this, but it seems to be too problematic for now...

thanks all
-hink
LibreOffice 5.4.5.1 on Linux Mint 18.3
echo8hink
 
Posts: 10
Joined: Wed Mar 02, 2016 7:59 pm


Return to Extensions

Who is online

Users browsing this forum: No registered users and 1 guest