Connecting to MYSQL via MS Access

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

Re: Connecting to MYSQL via MS Access

http://www.aspfree.com/c/a/Microsoft-Access/An-Access-Front- End-to-MySQL/
"csgraham74" wrote in message
news:1143917361.502030.12310@u72g2000cwu.googlegroups.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
>

Re: Connecting to MYSQL via MS Access

http://builder.com.com/5100-6388-1050135.html
"csgraham74" wrote in message
news:1143917361.502030.12310@u72g2000cwu.googlegroups.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
>

Re: Connecting to MYSQL via MS Access

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/en/myodbc-configuration. 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/en/programs-known-to-wor k-with-myodbc.html

Regards,
Bill K.

Re: Connecting to MYSQL via MS Access

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

Re: Connecting to MYSQL via MS Access

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/en/deleted-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.