MySQL

[Bill LAI]

Hi all,
When you are using Access DB, why don't you consider to use MySQL DB as
your choice?
When I was you, I used Access DB for personal and smallest data store, but
when I ruu up a DB service, I would like to use MySQL instand. MySQL is a
good choice to you when you set up a database service.

Bill LAI

 

[Tony Toews [MVP]]

When you are using Access DB, why don't you consider to use MySQL DB as
your choice?

Because MySQL is still missing some important features. Or did they
just add referential integrity to one version of MySQL?

It's more work to get an app going in SQL Server/MySQL/Oracle/whatever
than it is using an Access MDB for your data. And many times there
is no good reason for doing so.

That said I'd like to see some improvements in Accesses integration
with SQL Server to make it easier to work together.

When I was you, I used Access DB for personal and smallest data store, but
when I ruu up a DB service, I would like to use MySQL instand. MySQL is a
good choice to you when you set up a database service.

Where reasonable I would suggest SQL Server or SQL Server Express as I
strongly suspect it would integrate easier with Access. And SQL
Server Express, and it's predecessor MSDE, are free. Although with
some limitations.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/