[Solved] Second MySQL database crashes Base

[evwool]

I've finally got one MySQL database running with an OpenOffice front end, now I wanted to create another one. So I created the database itself in MySQL and then tried to connect to it with Open Office using the same procedure as I had for the first one, The Connection was established when I tested it in the OOBAse Database Creation Wizard but when I got to the final stage and saved the database as an Open Office file, as soon as I pressed Save, I never got to press finish because open office crashed and I had to restart my PC before I could do anything with any OO file again. The Base file is there in my folder but it won't open at all. I think I've misunderstood something about having more than one MySQL database with Open Office at the front end. What is it?

[evwool]

OK Got it! I don't have to do that connecting thing again. In fact I can't. I just create the database in MysQL and it will appear in the database window of my existing database. I can even slide tables into it from an existing Base Database. It bellyaches about not being able to find the correct column type for my text files but actually does just fine.

That database window is certainly going to get very full when I start creating more databases and putting forms in there for each one! I really didn't expect that. Do you MySQL users only ever have one database at a time or something?

[eremmel]

Time to join a MySQL forum as well?

[evwool]

Time to join a MySQL forum as well?

It certainly is, eremmel!