I just installed Open Office V2.3.1 on a Windows Xp pro system. Already familiar with 'Access', I created a number databases with no problem. Then I tried to set one as 'password protected', so that I had to enter a password to open that database under Base.
I went to 'options' and set the program to use the openoffice.org dialogs as instructed in the help files. The help files said to then do a 'Save As', and check the 'password' box, so it would set a password.
I did that and was asked for a password which I typed in and verified.
I then exited the base program and restarted, it, (just to be sure), and opened that database, expecting to be asked for a password. However it didn't ask for a password and opened the database in normal mode, allowing me to add information.
I looked in the directory where I save my databases, and noticed another database with the same name but with an 'odt' extension. I opened this database by double-clicking on the file and Base came up and asked me for a password. I typed in the password, and base opened the database up.
I thought I was home-free, until I tried to add more data to the database. Normally there is a navigation toobar at the bottom, which wasn't there on this 'odt' file. I went to 'view' and checked the 'navigation' toolbar to make it visible. It is now visible but the previous and next 'record' arrows and most of the toolbar options are greyed out.
There doesn't seem to be any way to add data to this database, but it does ask for a password when I open the 'odt' file.
Am I doing something wrong? Or is it not possible to password protect a database under Base?