Using Access Database & PHP

[JamesU2005]

I am thinking of creating a website that uses an Access Database to store data (surprise, surprise ).

The reasons for using Access over MySQL is because I find it so much easier to use.

Anyway, I have always been told there are performance issues, but I have never seen or found anything concrete.

So just wondered if anyone could give me more evidence on the matter.

Cheers

 

[Pho]

How do you find access easier? The SQL should be practically the same. If you mean the actual setting up the databases have you used phpMyAdmin? it doesn't get much easier, there's also plenty of useful software on the MySQL website.

 

[kiwi]

seriously, step away from the access, especially for web-based stuff.

 

[toString]

I heard once that there's a limit on the number of connections to the access database, something like 100 odd? I could never find a source to back it up though.

 

[JollyGreen]

I heard once that there's a limit on the number of connections to the access database, something like 100 odd? I could never find a source to back it up though.

There's no technical limit, however performance degrades dramatically for more than 10-12 concurrent connections.