Using Microsoft Access as a database

[mayo5000]

HI all,
I am creating a small dynamic website and have created it using MS Access as
the database. I have tried to get the data into MYSQL (succefull) and use that
but I cant even get MYSQL properly set up. The SQL queries that work on access
do not seem to work with MYSQL.

So the question to someone who can help me. Could I keep using MS access as a
database or is it definitely not relaibale for even a small commercial dynamic
website.

Thanks in advance...

Mayo

[Dan Bracuk]

The s in sql stands for structured, not standard. Every database has it's own
syntax and it's own functions so whenever you switch, you have to expect things
to not work at first.

Access is not unreliable. You might have some performance issues if you get
too much data, but if you do, do something about it. Also, because it has to
reside on your application server, you might run across some issues if you get
into load balancing.

But you know what your situation is. We don't.

[mayo5000]

Thanks for that Dan. The qick reply is much much appreciated.

[Rick]

Have you thought about MS SQL Desktop it is free. It is the same as SQL 2000
with some limitation but unless you are going to have a lot of people on at
the same time or your database a very large it works quite nice.


"mayo5000" <webforumsuser@macromedia.com> wrote in message
news:dqpje7$br4$1@forums.macromedia.com...

> HI all,
> I am creating a small dynamic website and have created it using MS Access
> as
> the database. I have tried to get the data into MYSQL (succefull) and use
> that
> but I cant even get MYSQL properly set up. The SQL queries that work on
> access
> do not seem to work with MYSQL.
>
> So the question to someone who can help me. Could I keep using MS access
> as a
> database or is it definitely not relaibale for even a small commercial
> dynamic
> website.
>
> Thanks in advance...
>
> Mayo
>