[thelist] ms access website solution?

[Ken Schaefer]

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Andrew" <andrew at humanbehaviour.co.uk>
Subject: [thelist] ms access website solution?


: I wouldn't consider using ms access as an online DB
: solution however a role I have just taken requires I complete
: a job already started by another company. My instrinct is
: saying scrap this and start again using php and mysql but dont
: seem to be aboe to justify scrapping someone elses work!
:
: Can anyone give me a few good reason s just to ease my
: conscience :)
:
: why would anyone even consider using Access as
: a website DB is beyond me.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Hi,

a) Access is easy (especially if the users also have an offline database and
they need to move data between the online and offline copies)
b) Access works fine for small databases, on non-critical applications

Hopefully that addresses your last point.

OK, onto the main body - what is the application currently written in? You
don't mention at all, yet you want to replace it with PHP. I assume that
it's not currently written in PHP. Does it have some kind of DAL (Data
Access Layer). Does the DAL have some kind of provider/drive mechanism that
allows you to target individual data stores? If so, then just create a new
bit of code to allow a mySQL database to be used (or MSDE)

Cheers
Ken