Connecting to MYSQL via MS Access

[csgraham74]

Hi,

I have recently decided to start using MYSQL instead of MS Access 2003.

After reading through numerous articles i have learnt that i can use
access as a GUI for making changes etc to the MYSQL databases.

My problem is that i am unable to set this up correctly - would anyone

be able to give me a set by set guide on how to do this or give me a
link to a site or post that outlines how to do this.

i have searched google without much luck at this point.
I have attempted to use the odbc method but i do not know what to
browse for when the wizard prompts me to browse. i have never use this
method before.
thanks
colin graham

[Jim Whitaker]

http://www.aspfree.com/c/a/Microsoft...-End-to-MySQL/
"csgraham74" <cs********@gmail.com> wrote in message
news:11*********************@u72g2000cwu.googlegro ups.com...

Hi,

I have recently decided to start using MYSQL instead of MS Access 2003.

After reading through numerous articles i have learnt that i can use
access as a GUI for making changes etc to the MYSQL databases.

My problem is that i am unable to set this up correctly - would anyone

be able to give me a set by set guide on how to do this or give me a
link to a site or post that outlines how to do this.

i have searched google without much luck at this point.
I have attempted to use the odbc method but i do not know what to
browse for when the wizard prompts me to browse. i have never use this
method before.
thanks
colin graham

[Jim Whitaker]

http://builder.com.com/5100-6388-1050135.html
"csgraham74" <cs********@gmail.com> wrote in message
news:11*********************@u72g2000cwu.googlegro ups.com...

Hi,

I have recently decided to start using MYSQL instead of MS Access 2003.

After reading through numerous articles i have learnt that i can use
access as a GUI for making changes etc to the MYSQL databases.

My problem is that i am unable to set this up correctly - would anyone

be able to give me a set by set guide on how to do this or give me a
link to a site or post that outlines how to do this.

i have searched google without much luck at this point.
I have attempted to use the odbc method but i do not know what to
browse for when the wizard prompts me to browse. i have never use this
method before.
thanks
colin graham

[Bill Karwin]

csgraham74 wrote:

After reading through numerous articles i have learnt that i can use
access as a GUI for making changes etc to the MYSQL databases.

My problem is that i am unable to set this up correctly - would anyone
be able to give me a set by set guide on how to do this or give me a
link to a site or post that outlines how to do this.

You need to install MyODBC on the client host (the same host where MS
Access is installed), and configure an ODBC DSN for each database you
want to use.

http://dev.mysql.com/doc/refman/5.0/...iguration.html

The manual also has a lot of information on how to use the DSN to a
MySQL database in MS Access:

http://dev.mysql.com/doc/refman/5.0/en/msaccess.html

Also read the notes on MS Access here:

http://dev.mysql.com/doc/refman/5.0/...th-myodbc.html

Regards,
Bill K.

[csgraham74]

Thanks very much guys that worked a treat - i only have two outstanding
issues.

a) some of my tables come up with the #deleted error in the columns
b) does anyone know how to export mysql so that i can set it up on ISP
windows server. is there some sort of export command to do this ??

thanks in adanvance

colin

[Bill Karwin]

csgraham74 wrote:

Thanks very much guys that worked a treat - i only have two outstanding
issues.

a) some of my tables come up with the #deleted error in the columns
This is apparently a common problem. The MySQL docs have a page about
it, and there are also additional user comments devoted to solving it.
Makes me glad I don't use MS Access. ;-)

http://dev.mysql.com/doc/refman/5.0/...d-problem.html
b) does anyone know how to export mysql so that i can set it up on ISP
windows server. is there some sort of export command to do this ??

This depends partly on your ISP, and what tools they offer for restoring
exported data. Many ISP's offer a web-based MySQL administration
interface called "phpmyadmin". This tool has a method for uploading SQL
scripts and running them. The script typically contains a series of
INSERT statements. You can generate this script from your local MySQL
database using the mysqldump tool.

http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html

Regards,
Bill K.