To reset password to default type

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.

  1. Rename the .odb extension to .zip
  2. Double click the .zip file to open with the OS archive viewer (I’m using Linux Mint)
  3. Double click content.xml to open with the default text editor
  4. Change is-password-required="true" to is-password-required="false"
  5. Save and close the editor.
  6. Back at the archive viewer, mine prompted whether to update the file in the archive. I confirmed with OK, closed the archive viewer, renamed the .zip to .odb and problem resolved.

Thanks @Ratslinger for pointing me in the right direction!