Base/MySQL use

users
#1

Mt patents want a database to manage their small business. My plan is to
have mySQL on a computer in the office contain the database and use LO Base
be the front end interface. 4 computers would access mySQL over the office
network. 1 computer would have access from the home computer.
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.

#2

Taylor ,

We are Using LO as frontend for a mySQL server, up to 50 users acces te data using LO.

I build my own FrontEnd using Dialogs an basic bundled in a extension to acces the data using Basic macro's and the native mySQL connector , works also from home using as VPN connection to the server
Basic + dialogs are fery powerfull but you can use also a Database document with forms to have acces to Mysql.
Then you must have a copy off the dabasedoc on all your machines .

Hope it helps

Fernand

#3

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