When you add any number formatting (how you want
Base to display certain fields) or queries (definitions which exact table data you want
Base to ask from the Access driver) or forms/reports (
Writer documents in
Base), this information is stored in the
Base file.
Working with the database as a user, editing database content in the ready made Base frontend, modifies the mdb fileonly. Just open some grid view, store some new information. The Base file should remain unchanged, but the mdb should change.
Close the Base file, rename or move the Access file, reload the Base file and the connection is broken until you put the mdb in the old place or point Base to the new location [menu:Edit>Database>connection]
I can't try. It is impossible do connect Access under Linux because MS does not publish any mdb drivers for Linux and as a matter of fact Base can not "open" mdb without the help of the database vendor (Access driver by Microsoft).
Your MySQL database has to be served by a server. It is a slightly more professional thing than Access and Base.
The connection to such a server is not specified by means of a file location C:\path\file.mdb.
Currently there are 3 different ways (3 different drivers) to connect a Base file to a MySQL server (notice that a server is a software that may run on the very same machine as the one you connect from).
As far as I know,
http://extensions.services.openoffice.o ... _connector is the latest, fastest, best and easiest way to connect Base with a running MySQL server.
http://wiki.services.openoffice.org/wik ... Native/1.0