Can't Open Database

MMEX4Desktop, incl. Windows, macOS (10.10 or newer), and Most Unix variants using the GTK+ toolkit

Moderator: Renato

strongbow
New User
Posts: 19
Joined: Wed Feb 26, 2014 9:32 am
Are you a spam bot?: No

Can't Open Database

Post by strongbow »

This morning Money Manager EX reported that my database had been flagged as open by another instance of Money Manager EX. After several attempts at solving the problem I copied the database to a USB stick and opened it on another computer. On the second computer Money Manager EX opened the database and let me make changes, so it seems that the problem doesn't lie with the data.

Back to the first computer: I deleted all Money Manager EX data; Uninstalled and reinstalled Money Manager EX; Copied the updated database from the USB stick to a new location. Money Manager EX seemingly allows me to open this copy of the database, but sits there without showing anything. N.B. I say it seems to be opening the database because the timestamp is changing and a backup database is created, but I can't see any of my data!

Any help/advice/ridicule gratefully received.
User avatar
Renato
MVP User
Posts: 669
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

Re: Can't Open Database

Post by Renato »

Renato Forum Administrator
strongbow
New User
Posts: 19
Joined: Wed Feb 26, 2014 9:32 am
Are you a spam bot?: No

Re: Can't Open Database

Post by strongbow »

Many thanks for the prompt reply Renato. Unfortunately the topic you provided a link to has not helped. I installed Revo Uninstaller and used it to delete Money Manager EX, which I then reinstalled.

Same result I'm afraid. Money Manager EX seems to open the database (the file's timestamp is changed AND a backup is created) but there is no VISIBLE action, so I cannot see or amend my data.

This is a serious problem for me, although it is NOT urgent (strange dichotomy there) because I have another computer I can use in the short term.
User avatar
Renato
MVP User
Posts: 669
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

Re: Can't Open Database

Post by Renato »

I suspect that there is still a portable MMEX version available and that it contains another version.
Probably the REVO Uninstaller will not delete this portable version and its link.
The portable version for MMEX should only be installed / used on a stick.
Renato Forum Administrator
strongbow
New User
Posts: 19
Joined: Wed Feb 26, 2014 9:32 am
Are you a spam bot?: No

Re: Can't Open Database

Post by strongbow »

Thanks once again Renato.

It seems unlikely that a portable version is the culprit - I have NEVER installed or used a portable version of the software.

I have no idea what to try next!
strongbow
New User
Posts: 19
Joined: Wed Feb 26, 2014 9:32 am
Are you a spam bot?: No

Re: Can't Open Database

Post by strongbow »

Problem Solved (although I'm not sure how), but this is what I did:

Added the second computer to the network, so that both computers could "see" the same copy of the database; Uninstalled Money Manger (again) using Revo Pro; Removed the Money Manager installation file; Installed Money manager from a newly downloaded copy of the installation file; Started Money Manager and opened the existing database.

Bingo!

Thanks for you help Renato.
TimP58
New User
Posts: 5
Joined: Wed Nov 22, 2017 10:44 pm
Are you a spam bot?: No

Re: Can't Open Database

Post by TimP58 »

It may be a coincidence but I have just started to experience exactly the same symptoms as the OP has, of being unable to start MMEX successfully after being a user for more than 3 years. I have tried uninstalling and cleaning the registry with CCleaner and then doing a reinstall but the results are the same, the program appears to start but hovering over it on the taskbar just shows a small blank window.

My computer has just updated to windows 10 version 2004 which leads me to think this is somehow involved. Has anyone else had this experience?
User avatar
Renato
MVP User
Posts: 669
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

Re: Can't Open Database

Post by Renato »

and what is under "Help / About
would be correct:
MMEX11.jpg
MMEX11.jpg (39.81 KiB) Viewed 4302 times


please read on here: viewtopic.php?f=10&t=9358
Renato Forum Administrator
TimP58
New User
Posts: 5
Joined: Wed Nov 22, 2017 10:44 pm
Are you a spam bot?: No

Re: Can't Open Database

Post by TimP58 »

Renato since I can't open the program I can't read the help file.

I appreciate you are trying to help but the advice is a bit obscure. What I take away from this exchange is that the stable release v1.3.5 of MMEX will not run on the latest version of Windows 10? I don't understand the links to other posts about downgrading the db version, since I can't get the program to run I can't run the SQL script that has been provided.

I have downloaded the portable version of v1.3.5 and bizarrely it runs and works fine. It even has exactly information in the About windows as in your post.
User avatar
Renato
MVP User
Posts: 669
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

Re: Can't Open Database

Post by Renato »

Delete C:\Users\YOUR-USERNAME\AppData\Roaming\MoneyManagerEx\mmexini.db3
Renato Forum Administrator
TimP58
New User
Posts: 5
Joined: Wed Nov 22, 2017 10:44 pm
Are you a spam bot?: No

Re: Can't Open Database

Post by TimP58 »

So that worked, who knows why but everything is working again. I hope others might see that advice and benefit from it.

Many thanks Renato
User avatar
Renato
MVP User
Posts: 669
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

Re: Can't Open Database

Post by Renato »

Many thanks for the feedback.

Yes, as I have often written, the configuration file mmexini.db3 is often damaged by this problem.
Renato Forum Administrator
Sherpa5
New User
Posts: 3
Joined: Mon Sep 07, 2020 1:33 am
Are you a spam bot?: No
Location: España - Madrid
Contact:

Re: Can't Open Database

Post by Sherpa5 »

Ayer pedia ayuda ya que no podia abrir la págna del programa MMEX_My money. debo informar que uso Window 10 y el programa desde hace 10 años como minimo, siguiendo las indicaciones de TimP58, he copiado en un disco externo los archivos de datos y seguidamente borre todos los programas y carpetas que tenia de Money.
Seguidamente me he vuelto a bajar la aplicación 1.3.5-win64 , acción realizada anteriormente siguiendo los consejos de actualizar el programa,con resultado del error, pero hoy ya FUNCIONA CORRECTAMENTE, si bien no se ha creado el Enlace directo en el Escritorio y compruebo que para subir a Excell los informes NO Funciona, se direcciona a petición de datos a Internet http:/// ......
Gracias por su atención .
User avatar
Renato
MVP User
Posts: 669
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

Re: Can't Open Database

Post by Renato »

hola Sherpa5
Este es un foro de habla inglesa.
No sé español y la traducción no explica el problema.
Renato Forum Administrator
bransonbe
New User
Posts: 1
Joined: Mon Sep 14, 2020 1:43 pm
Are you a spam bot?: No

Re: Can't Open Database

Post by bransonbe »

Hi All,

MMEX doesnt want to open fully, after my computer did a compulsory update this morning.

I am running Windows 10 Home, Windows Build 19041.450

The Money Manager App opens, but then is a blank white screen.

Any idea of what I need to do to get it back up and running.

Hate the windows updates!

Please help! Desperate! Love your app!!!
Attachments
MMEX 1.jpg
MMEX 1.jpg (59.65 KiB) Viewed 4083 times
User avatar
Renato
MVP User
Posts: 669
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

Re: Can't Open Database

Post by Renato »

Renato Forum Administrator
dbolton
Super User
Posts: 126
Joined: Fri Jan 03, 2020 3:24 pm
Are you a spam bot?: No
Contact:

Re: Can't Open Database

Post by dbolton »

@bransonbe In your screenshot it looks like the window might just be off screen. You might try the suggestions in this article: https://www.howtogeek.com/howto/windows ... ard-trick/

This can happen if you switch between multiple monitors and one monitor (e.g. undocking/unplugging a laptop computer).
Nikolay
Developer
Posts: 1535
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: Can't Open Database

Post by Nikolay »

pdh
New User
Posts: 3
Joined: Fri Sep 25, 2020 10:02 am
Are you a spam bot?: No

Re: Can't Open Database

Post by pdh »

As a new member of this forum but not a new user of MM I hope I will be forgiven (a) if this has been mentioned before or (b) if this question is in the wrong place or (unlikely) out of order. I have noticed by looking through recent threads and posts that a fair number of people have been having difficulties in accessing their files for a variety of reasons with a number of people, including myself, being unable to 'get in' as the program reports that the db is already open. This isn't the first time I have experienced this. The most recent solution suggested by Renato worked for me and others to whom it was suggested. This solution was to delete C:\Users\YOUR-USERNAME\AppData\Roaming\MoneyManagerEx\mmexini.db3. I renamed the file initially rather than deleting it but sure enough it did the trick and a new .db3 was created next time I exited the program.

I presumed therefore that my .db3 file had become corrupted. If that is the case and this is happening to others too is this a problem that the Developers would look at as it must put a lot of people off MM unnecessarily. Personally, even with this occurring to me more than once over the years, I rate MM highly and would hate to see people put off using it due to what I would call a 'bug'.

Is it worth someone looking at this issue to see if an answer can be found to prevent it?
User avatar
Renato
MVP User
Posts: 669
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

Re: Can't Open Database

Post by Renato »

I am also of the opinion that a correction is due here.
But it is just that the programming capacity depends on the availability of volunteer programmers.

Most of the time it is very difficult to find the error, especially if you have no further information how the error was created.

May I ask you to send me the broken and the working .db3 file via PM. (there is no confidential data in it, only settings)
Renato Forum Administrator
Nikolay
Developer
Posts: 1535
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: Can't Open Database

Post by Nikolay »

Nikolay
Developer
Posts: 1535
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: Can't Open Database

Post by Nikolay »

Thank you, Renato, for the "defective" mmexini.db3 file. Using this, I am sure I can fix this problem.
Polycarpe
New User
Posts: 1
Joined: Sat Nov 07, 2020 11:28 am
Are you a spam bot?: No

Re: Can't Open Database

Post by Polycarpe »

I have the same problem. I cannot open my database on my laptop (windows 8.1). This started after upgrading to version 1.3.5 . But when I take the same database on a USB to my office desktop (windows 7), on which I have installed money manager same version 1.3.5; it opens with no problem. I am able to make changes and save them. When I bring the new database back to my laptop, it does not open. I get a message saying that the database is already opened with an other session of money manager. Strange!!!
User avatar
Renato
MVP User
Posts: 669
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

Re: Can't Open Database

Post by Renato »

probably the solution is a bit further down:

This solution was to delete C:\Users\YOUR-USERNAME\AppData\Roaming\MoneyManagerEx\mmexini.db3
Renato Forum Administrator
Eddietheone
Senior User
Posts: 35
Joined: Sun Sep 02, 2018 4:33 pm
Are you a spam bot?: No

Re: Can't Open Database

Post by Eddietheone »

I too now cannot open any database in 1.3.5 just like detailed in the thread. I have tried to find the pathway listed by Renato but cannot. If anyone can help me get it to open again I will be grateful otherwise I shall have to look for another program that will work. I too have no other program that I have tried to open the files with so why it keeps saying it is open in another program beats me.

Cheers Edward
Post Reply