[Glastonbury] OOo and MySQL

[Martin WHEELER]

On Sat, 24 Jan 2004, Rob Cornelius wrote:

> The problem is that the people who work there have about 3 sessions at
> night school doing CLAIT between them.

Hmmm, highly educated as typical clients go.  They must be in higher
education.  [Sorry.  Sorry.  Naughty Martin.  Mustn't do that.]


>  Therefore the only database front
> end they can use is Access. (I go there and type queries into the mysql
> command line and they refuse to believe the results I get out) They
> wouldn't know a select statement if it bit them.

OK, so it looks as if you're going to have to write a font-end for them.
PHP and a web-browser is the usual way forward.  (They can cope with a
web-browser can't they?)
[see  http://glastonbury.gov.uk/BizBase/search.html  for a dumb db query
front-end cobbled together out of perl, php and mysql + browser.]


> need a database front end that is as much like access as possible....
> THe only one I know of at all for linux with a "point and click, drag
> and drop" query designer is Open Office. Hence my predicament.

I've never tried getting OpenOffice's database interface to work -- it's
always been the weakest link of the suite as far as I'm concerned.
Doesn't sound like you need anything massively complex at the moment
though -- what sort of requirements will your punters begin to ask for
as they get used to using the system?  Can they be fobbed off forever
with a fixed-format query tool?

Cheers,
-- 
Martin Wheeler   -   StarTEXT / AVALONIX - Glastonbury - BA6 9PH - England
mwheeler at startext.co.uk                http://www.startext.co.uk/mwheeler/
GPG pub key : 01269BEB  6CAD BFFB DB11 653E B1B7 C62B  AC93 0ED8 0126 9BEB
      - Share your knowledge. It's a way of achieving immortality. -