[thelist] ms access website solution?

david.landy at somerfield.co.uk david.landy at somerfield.co.uk
Fri Apr 30 08:33:44 CDT 2004

A bit past the sell-by date on this one, but here's my 2c worth...

I'm an Access fan, and given all the (perfectly sound) reasons Nick gave for
preferring MySQL over Access, I'm now asking myself, "why?" - apart from the
fact that it's the devil I know ;-)

Here are the things that come to mind:

1. I can easily cut code to tweak the data in VBA - but then again, I could
also link MySQL tables and do it that way, so this doesn't count.

2. Wizards for complex queries - but I could run them and then port the code
to MySQL, so this doesn't count either!

3. Crosstab queriy support for data roll-up is built-in, with a great wizard
- does MySQL have this?

Apart from that, it sounds like MySQL knocks the socks off it in terms of

And of course, MySQL wasn't hobbled by Microsoft as a web db in later MDAC
releases which arbitrarily limit the number of active connections to an
Access db for no good reason that I can see, and also prevent changes to
data in Access 97 db's, also seemingly for no good reason!! To me, it seems
like both of these moves were designed to "encourage" web designers into
buying MS-SQL Server, and/or upgrade to Access 2000+. But maybe I'm being
too suspicious?



David Landy, IT Consultant, Business Intelligence
Somerfield/KwikSave Support Centre
Whitchurch, Bristol, UK. Tel: 0117 301 8977
david.landy at somerfield.co.uk <mailto:david.landy at somerfield.co.uk>    
This is the true joy of life. The being used for a purpose 
Recognized by yourself as a mighty one. 
George Bernard Shaw

If you are not the intended recipient of this e-mail, please preserve the
confidentiality of it and advise the sender immediately of any error in
transmission. Any disclosure, copying, distribution or action taken, or
omitted to be taken, by an unauthorised recipient in reliance upon the
contents of this e-mail is prohibited. Somerfield cannot accept liability
for any damage which you may sustain as a result of software viruses so
please carry out your own virus checks before opening an attachment. In
replying to this e-mail you are granting the right for that reply to be
forwarded to any other individual within the business and also to be read by
others. Any views expressed by an individual within this message do not
necessarily reflect the views of Somerfield.  Somerfield reserves the right
to intercept, monitor and record communications for lawful business

More information about the thelist mailing list