[Sheflug] Re: Access to MySQL

[Richard Ibbotson <richard [at] xxxxxxxxxxxxx>]

Matt

Thanks to everyone and Matt for the helpful advice..

> Define "convert" exactly, in these circumstances.  There are several levels:

Just now it's an Access database.  The owner wants to have it
converted to MySQL.  Presumably I can use the MySQL ODBC app so that
M$office can connect to MySQL.

> * Data stored in MySQL, existing Access application for front end;

Could be.

> * Data stored in MySQL, Access for front end but migrating to something else
> (GNUe, some Webapp, or whatever) over time;


This looks good but probably requires a lot of work.

> I'm in an ongoing project to do the second of those options at present.


Oh... good news :)


> If you're going with option 1, you can do a simple outload, relink all the
> tables, install MyODBC on all the windows clients, and collect your cheque.

Probably the best thing to do.  Get out before something else comes
up. :)


> in your choice of PHP, Perl, Java, or whatever (which is my world at the
> moment - PHP webapp to replace Access system).

I thought about that.  Good way to learn more about PHP.  They have PC
Anywhere on the network.  Like to get rid of it and replace it with
SSL through a web browser.  Cheaper and easier to maintain.

> Anyway, if you can give a pile more details about what you're doing, I can
> provide more details, and if you pester me appropriately, I might remember
> to dig up my VBA scripts to do data conversion when I'm at work.


Might be good.  I'll have a think about it.

Thanks




Richard
___________________________________________________________________

Sheffield Linux User's Group -
http://www.sheflug.co.uk/mailfaq.html

  GNU the choice of a complete generation.