[libreoffice-users] Re: Base/MySQL use

Le 30/10/13 18:03, Taylor Blake a écrit :

Hi,

> Can I  (empty) the database from mySQL workbench, connect base and then
> build it from there? Then copy the base file to the other computers so all
> the forms and reports are available everywhere.


You can certainly use mysql as your backend and Base as your front end.
How you go about doing that is up to you, but as far as I know, you
can't connect an ODB file to MySQL Workbench, it wasn't designed for
that. By all means, design your database in MySQL Workbench, set up the
relations, keys, triggers, etc, and then execute that to create your
database within the mysql server instance. Then design your user
viewing/editing forms in LO Base, and either save them individually and
copy them to each computer requiring access to the UI, or else create a
single ODB file containing all of your queries, forms and reports and
copy that to each machine.

Alex


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted