Page 1 of 1

[Dropped] Can't open database I created

Posted: Fri Sep 08, 2023 10:12 pm
by Alanja46@gmail.com
Created a movie list db but can't open it. When I click on it I get openoffice base screen with create form or use wizard options. Nothing I try shows my list.

Re: Can't open DB I created.

Posted: Fri Sep 08, 2023 11:01 pm
by FJCC
What do you see if you click on the Tables icon in the left pane?

Re: Can't open database I created

Posted: Sat Sep 09, 2023 4:11 pm
by Nick N,
Alanja

Hello! What happened?

No Java Runtime? Any driver missing?

Please be so kind to let us know...

Have a nice day!

Nick :)

Re: Can't open database I created

Posted: Sat Sep 09, 2023 6:37 pm
by Alanja46@gmail.com
It says I need JRE which I have doanloaded to my laptop now but it still says the same. If I look for Java in programs it only shows Configure Java whichI open, apply and click ok. But still not opening file.

Re: Can't open database I created

Posted: Sat Sep 09, 2023 7:55 pm
by FJCC
You have to tell OpenOffice to use Java. Go to the menu Tools -> Options. Expand the OpenOffice list on the left and select Java. Select Use a Java runtime environment. Wait several seconds for the list to show the available Java. Click the radio button next to the listed Java and then click OK.
If no Java runtime environment is listed, then you probably downloaded a 64 bit Java. You need to download a 32 bit Java.

Re: Can't open database I created

Posted: Sat Sep 09, 2023 8:24 pm
by RoryOF
OpenOffice requires a 32 bit Java, which you can install alongside a 64 bit Java. You must then select the path to the 32 bit Java in /Tools /Options /OpenOffice :Java

Re: Can't open database I created

Posted: Sat Sep 09, 2023 9:07 pm
by Nick N,
Hello,

am astonished a little, because LO is native in ubuntu and it encompasses JRE environment, even if you have not yet downloaded Base.

Anyway, for AOO 4.x your JRE would be 1.8. Sorry if I cannot upload as its filesize exceeds limits.

With kind regards

Nick

Re: Can't open database I created

Posted: Sat Sep 09, 2023 10:24 pm
by Alanja46@gmail.com
Were correct, had d/l 64bit. D/l 32-bit and added it to Office. Now acts like it sees Java and does not tell me to add JRE but when I try to open the file it shows my Movies.odb on top but besides ; create form or use wizard options it now has create view but nowhere do I find my db.
Had no idea Office db was so convoluted to use. Excell always seemed to work for me back in the day.

Re: Can't open database I created

Posted: Sat Sep 09, 2023 10:29 pm
by FJCC
Well, a spreadsheet and a database are very different things. If you want to use a spreadsheet, use Calc in OpenOffice.
How exactly did you make this db that OpenOffice will not display?

Re: Can't open database I created

Posted: Sat Sep 09, 2023 10:39 pm
by Alanja46@gmail.com
I thought I just created it with Office and did some edits and sorts and saved it.

Re: Can't open database I created

Posted: Sat Sep 09, 2023 10:48 pm
by Nick N,
You meant: that's all Folks?

Are you closer to MS-Office, rather than AOO?

In any case, enjoy your job.

Regards

Nick

Re: Can't open database I created

Posted: Sat Sep 09, 2023 11:03 pm
by FJCC
Alanja46@gmail.com wrote: Sat Sep 09, 2023 10:39 pm I thought I just created it with Office and did some edits and sorts and saved it.
Please give more details. Did you make it with Excel? By Office, do you mean Microsoft Office?