Access 2000 and MySQL

[M]

A friend of mine has a website that sells goods and his
web provider uses MySQL. He wants a database connected to
his site and has no experience with databases. Never
having used MySQL, I know that Access 2000 can connect
using MyODBC. Let's suppose that I design a simple
backend with one table. Will MyODBC allow me to connect
with an Access front-end to view, update and delete
records? What would be the limitations of this pairing
and what would be the advantages?

Thanks for the help

M

 

[John Vinson]

Will MyODBC allow me to connect
with an Access front-end to view, update and delete
records?
Yes.

What would be the limitations of this pairing
and what would be the advantages?

I've done this once and was very impressed with its capabilities. You
will need to do table creation on the server, or by using MySQL DDL
queries as Pass-Through queries - you won't be able to use the Access
user interface to create tables directly.

 

[M]

Thanks for responding. Just as a curiousity, which
version of Access would be the best version to use?

Thanks

M

 

[John Vinson]

Thanks for responding. Just as a curiousity, which
version of Access would be the best version to use?

I don't know that the MySQL interface would be much different in any
recent version; I'd be inclined to use whatever you have installed, or
get the 2003 version if you don't yet have it.