Access v Mysql

[ian_ok]

Hi all.

It's been a while since I was on here. Hi to Rich, Pat and the other regulars.

I'll be running a website that needs a d/b and need some feedback.

What are the main pros and cons with access

What are the main pros and cons with Mysql

I know access and think I could get what I want a lot quicker.

My hosting company charges for using Mysql - I need to keep cost down.

Does access have problems if many people are using the d/b at the same time?

Thanks for any feedback.

Ian

 

[TexRanger]

Hi,
Answer to all your who,what why and whens
1]What are the main pros and cons with access
- Quick Turnaround
- Very Zippi response, provided you configure mysql properly
- Extremely good presentation
- Good master detail design type and versatile forms

2]What are the main pros and cons with Mysql
- same as above, but a wrong config could kill all the pros
- Access+MySQL combination is pretty quirky to get started with.

3]Does access have problems if many people are using the d/b at the same time?
- none that, i encoutered, I have about 50 persons working on a network database (MSQL 2008)

i hope this answers your questions