MySQL vs. Access

[Jordan Marton]

Which should I use? And is MySQL free? Does it need special software to run?
Advantages/disadvantages? And how difficult is it to move everything over
from access to mySQL?

Jordan

[Chris In Madison]

Hi Jordan,

There are quite a few opinions on this. You can check out a good number of
them here (watch the wrap):

[url]http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&q=mysql+vs.access&btnG=Google+Search[/url]

Best regards,
Chris

[Jordan Marton]

Thats great... I didn't realize google kept feeds of newsgroups... It looks
like I can basically find anything there now!

Jordan

"Chris In Madison" <cowens@cnwGOAWAYDIRTYRATSPAMMERS.com> wrote in message
news:bf3k4t$13v$1@forums.macromedia.com...

> Hi Jordan,
>
> There are quite a few opinions on this. You can check out a good number

of

> them here (watch the wrap):
>
>

[url]http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&q=mysql+vs.acces[/url]
s&btnG=Google+Search

>
> Best regards,
> Chris
>
>

[Jordan Marton]

On a subnote, a lot of the posts from there say that access is fine for
small sites and stuff. Does anyone know the limitations, how many
connections, size, and stuff?

Jordan

"Chris In Madison" <cowens@cnwGOAWAYDIRTYRATSPAMMERS.com> wrote in message
news:bf3k4t$13v$1@forums.macromedia.com...

> Hi Jordan,
>
> There are quite a few opinions on this. You can check out a good number

of

> them here (watch the wrap):
>
>

[url]http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&q=mysql+vs.acces[/url]
s&btnG=Google+Search

>
> Best regards,
> Chris
>
>

[Paul Whitham TMM]

There is a lot of debate on this. Urban lengend is that officially it is
supposed to support up to 256 simulateous connections, but there have been
reports of it starting to have problems as low as 10 simulateous
connections.

--
Regards

Paul Whitham
Valleybiz Internet Design
[url]www.valleybiz.net[/url]

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]
"Jordan Marton" <JMarton@HAHAmarketaxess.com> wrote in message
news:bf3mo6$6ne$1@forums.macromedia.com...

> On a subnote, a lot of the posts from there say that access is fine for
> small sites and stuff. Does anyone know the limitations, how many
> connections, size, and stuff?
>
> Jordan
>
> "Chris In Madison" <cowens@cnwGOAWAYDIRTYRATSPAMMERS.com> wrote in message
> news:bf3k4t$13v$1@forums.macromedia.com...

> > Hi Jordan,
> >
> > There are quite a few opinions on this. You can check out a good number

> of

> > them here (watch the wrap):
> >
> >

>

[url]http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&q=mysql+vs.acces[/url]

> s&btnG=Google+Search

> >
> > Best regards,
> > Chris
> >
> >

>
>

[Gary White]

On Thu, 17 Jul 2003 08:47:14 +1200, "Paul Whitham TMM"
<paul@valleybiz.net> wrote:

>There is a lot of debate on this. Urban lengend is that officially it is
>supposed to support up to 256 simulateous connections, but there have been
>reports of it starting to have problems as low as 10 simulateous
>connections.

And I have seen it corrupt data with two simultaneous writes.


Gary