You do not need to use MS Access nor would I recommend it to manipulate or
recreate the MySQL Server required tables (the 'mysql' db). The basic
install that comes with the MySQL Windows binary is sufficient to get you
started (including WinMySQLadmin). After you have created a few databases
and populated the tables, you really should try one of the third party MS
Windows tools for administrating your MySQL databases. As I had mentioned
earlier, I have had great success with MySQL-Front (
http://www.anse.de/mysqlfront/ ), but there are numerous others that many of
the individuals on this list have developed and offer as Freeware or
Shareware.
I hope this helps...
Pat...
----- Original Message -----
From: "Christ Mercury" <christian_mercure@stripped>
To: <patrick@stripped>
Sent: Thursday, December 27, 2001 11:39 AM
Subject: Re: Why I will stay with Microsoft SQL Server
> Hello Patrick,
>
> Thanks for the information.
> I am now able to link the user table in Access then close Access, close
> MySQL, restart again and easily reconnect to the user table and open it in
a
> query.
>
> I was definitely doing something wrong with the ODBC connection. I think
the
> combination of Host and User name in the USER table is where I was having
> problems. SQL Server is more concerned with the Login name than the
Machine
> name so I think the security systems under MySQL is different and I was
> having difficulties there.
>
> One last question if you don't mind:
> When I create a new database to import Access tables do I need to also
> recreate all the initial tables from MySQL (db, host, user, etc.) or is
only
> user created in table USER of database MySQL.
>
> Thanks
> Christ
>
> >From: "Patrick Sherrill" <patrick@stripped>
> >To: "Christ Mercury" <christian_mercure@stripped>
> >Subject: Re: Why I will stay with Microsoft SQL Server
> >Date: Wed, 26 Dec 2001 07:47:26 -0500
> >
> >You need to create the DSN from the ODBC control panel applet. The
actual
> >vernacular is dependent upon which version of MS Windows you are using.
> >Assuming you are using MS 2000, click on 'Start', then select
> >'Settings--->Control Panel'. From the Control Panel Menu select
> >'Administrative Tools' and click on 'Data Sources (ODBC)'. From the ODBC
> >Data Source Administrator select the 'System DSN' Tab and click 'Add'.
> >Select the 'MySQL' Driver. Complete the MyODBC Panel:
> >
> > Windows DSN name: (whatever you want)
> > MySQL host: localhost (if your MySQL Server is not
> >running on the same computer enter the IP address of the Server)
> > MySQL database name: (the name of the database you created on
the
> >MySQL Server)
> > User: root (or whatever user you may have
> >created, use root with no password if you have not added any users)
> >
> >Leave the remaining fields blank.
> >
> >Now fire up MS Access and create a new link table selecting ODBC file
type,
> >then select the name of the DSN you created above.
> >
> >Pat...
>
>
>
> _________________________________________________________________
> Chat with friends online, try MSN Messenger: http://messenger.msn.com
>
