druagord — Fri, 23 Jul 2004 16:46:25 +0000

access is a little one to 5 user database it's engine is slow and nothing as been done to make better for the web. comparing access to any sql server is like comparing paint and photoshop.

vexcom — Fri, 16 Jul 2004 05:22:04 +0000

MySQL is free and is so much better than access that it makes me lightheaded.

Access + WWW = bad

MySQL + WWW = good

openmind — Sun, 04 Jul 2004 16:17:39 +0000

Access includes an upsizing tool to migrate to MS SQL. There are also plenty of tool s out there to move to MySQL as well.

m3rajk — Sun, 04 Jul 2004 16:15:33 +0000

is access sql compatible?
if not you might want to set up a dev server and migrate everything to using the php pear db so that you can interact with any sql. or to a specific sql if you would like.

and then move things over once you have your scripts working.

remeber, it's very easy to make a very small mistake that causes big headaches, so always try to test first.

openmind — Sun, 04 Jul 2004 13:03:20 +0000

There's a couple of schools of thought here. Access is not a production database and is limited in the number of concurrent connections it can suypport. I used to run a site serving 250,000 page views on an Access DB (shudder) and it coped...just

Looking back I should have made the switch to MS SQL sooner but hey you live and learn. If your site is getting weird now on the level of traffic you are getting I would make th switch sooner rather than later. Don't forget that you could also use MySQL if the cost of MS SQL from your host is prohibitive..