i used ALTER USER “SA” SET PASSWORD “something” in split database
after this popup asking password this ok but now want simple direct opening base file without password login popup.
i used ALTER USER “SA” SET PASSWORD “”
i set password blank but don’t get rid of popup.
any advice to get out of username and password popup screen
This appears to be a bug. From main .odb screen go to menu Edit->Database->Properties... you will see Password required is selected. You can remove the selection and save but it never gets cleared no matter what. That is the bug.
You can fix with an edit to a file in the .odb. Best to have a copy of the .odb in case you mess something up in the process. It’s simple but best be safe. Open the .odb with an archive program. Then open the content.xml file with a text editor. In the file you will find the following item:
is-password-required="true"
Change to:
is-password-required="false"
Save the file and the content of the .odb and then you should not have the popup anymore.
this process is works… thanks
I first asked what kind of archive program to use, as Linux Mint’s Archive Manager, pzip or gzip don’t like the .odb file extension. Then I found an article on fileinfo.com saying I could simply rename the .odb to .zip and open it. That worked, but trying to re-compress the files into a .zip and renaming to .odb gave me a “Corrupt file” error when loading with LO. The original poster seemed to like your solution, but … I guess I’m missing something and am now editing my original question. Can you give specifics?
I was a little slower figuring this out, but there’s another post here that made it a little clearer.
is-password-required="true" to is-password-required="false"
Thanks @Ratslinger for pointing me in the right direction!