NEED A STEP-BY-STEP: HOW TO CONNECT ACCESS FRONT-END ON CLIENT TO NETWORK SERVER

If you are trying to connect a MYSql client to the server use the above recommendation.
If you are trying to connect Access to a MySql database and use access to do queries etc. then download the MYSQL ODBC connector from MYSQL.com (free).  Install the connector, connect to your database host name etc and test the connection.  Once connected open access, go to File, Get external data, link tables select Connect via ODBC in the file type option.  You can then select some or all of the tables in your MYSQL database.

Good Luck,

/Joe

Joe Cool's got it right-- Access front end--

well, that last part is what I'm trying to do-- and where I'm having a bit of trouble:

I open Access on a client machine, but it doesn't seem to be able to see the system DSN (or is it DNS, I forget) connection.  What do I have to do so the clients can see a DNS created on the server?

thanks

--n

Hai,

You have to create "File DSN" on server and on client system you have connect it to that file dsn by changing the combobox [Look in] to the network path.

Bye
Ajai

OK,

I'm at the client's location now, and I've tried creating an ODBC File DSN on the Server to connect to the mySQL database.  That connection seems to be working.  However, when I go to my client machine (which also has the mySQL ODBC driver installed) and try to "connect" to it (via both network path AND trying to map a network drive to the Data Source folder) the connection fails.

What am I doing wrong?  It seems like it should be pretty straight forward--

PLEASE HELP!!

n

Hai,

The Easiest Method is.

On Client System.
1. Create And DSN pointing to your MYSQL Server database.
2. Create a new database on MS-Access.
3. On New Access Database Select File -> Get External Data -> Link Tables.
4. Select the [files of type] to ODBC.
5. On [Select Data Source] window select the tab [Machine Data Source]
6. Select the DSN which you previously created.(Which is linked to MYSQL database) and ok.

This will link all the tables of mysql database.

Hope this helps you better.
Bye
Ajai

Hai,

See this too... http://dev.mysql.com/doc/connector/odbc/en/faq_4.html

Bye
Ajai

thanks for your reply--

What hangs me up is the first step-- If I try creating a System DSN on my client machine, I don't see a way of connecting to the mySQL database on the server.  I need some detail on how to troubleshoot that and what to look for exactly.  All the rest is pretty easy.

I'll check out that link too

thnx--  I'll let you know

n

so far, I've only added teh odbc driver on the client machine.  It looks like I have to install the full version of mySQL as well.  But here's the burning question-- when I do, should my DSN that I set up on the server suddenly appear for me to connect to?  I think that's the one thing tripping me up.

Hai,

Download MySQL Driver (MyODBC) and install it on your client system... Then you can see the MySQL Drive type on your bottom of your drivers window (before MS SQL Drivers).

http://dev.mysql.com/downloads/connector/odbc/3.51.html

Bye
Ajai

THANKS A TON FOR THIS!!!   I know I'm now just getting annoying-- but I don't have any user passwords and on the server I created an ODBC connection with no user name or password and I could connect to it.

But on the client I get the following error:  Access denied for user: '@%'

Any tips on that?

thanks a TON!

norm

I GOT IT!!  OK, I checked the mysql database, users table and typed "root" in the user name box in the configuration area of the mySQL connector ODBC on the client machine (that was a mouthful) and VOILA-- I tested the connection and it was successful!!  Thanks a ton!!