Chris Green wrote:
[SNIP]
In the end, yes, maybe. It's actually quite a simple application and an HTML/PHP front end would be a brilliant idea. However a 'quick and dirty' bodge for the moment would be useful too!
I wonder what you can do with Mono (http://go-mono.org)? Mono will probably understand your Basic code and you could easily extract your SQL from Access and insert it into MySQL......
Thanks for the link. However I suspect that it might take almost as much effort as biting the bullet and doing it 'properly' using PHP or whatever. (Especially given my lack of knowledge and dislike of VB)
Chris,
There are a number of free (and non-free) tools to convert access to MySQL. We use one, but I forget which, and there's no-one here right now to ask. It's easier to develop the db structure in the Access GUI and convert to MySQL than to hand code it.
Once it's in MySQL, phpmyadmin will prove a real boon with managing it and the data therein.
As you say, php/html would be a good exercise for your lad! Get him to sign up for phpclasses (see http://www.phpclasses.org/) as in code not lessons.
Cheers, Laurie.