> 1. Does anyone have any experience of this kind of migration that they could
> share with me?
I have done plenty, it should be really easy.
> 2. For the meantime I want to keep the Access system on the desktops, mainly
> because that is what the users are used to. Are there any problems with the
> integration of the two databases?
Nop, there shouldnt be any
> 3. I'm assuming the only connection option I have is ODBC?
Yes, unless you want to do everything with VB using libmysql.dll
> 4. Is anyone aware of any comparisons that may have been done by people in
> the past that could help me make a decision?
I can't remember the url, but it's somewhere on www.tcx.se
> 5. Have I missed out any databases?
Yes, sybase is also being given out for free in linux operating systems.
> 6. If (in the future) I wanted to move the desktop machines to Linux, are
> there any tools like Access/VB available (or in the pipeline) that I could
> use to re-build the "front-end"?
You can use pretty much anything....VC, C++ Builder, Borland C++, Delphi
Regards,
Jorge del Conde