Arthur Fuller
artful at rogers.com
Tue Feb 11 09:42:58 CST 2003
It's not difficult at all, but there are a couple of potential gotchas. 1. Install MySQL. Decide whether you want it set up as a service. If so, start winMySQLAdmin and set it up to start automatically. 2. Ensure that you can hit the server with the mysql client. 3. Install MyODBC. This will add two data sources to your list of ODBC data types. 4. Create a new DSN that points to the mysql database called test. 5. Create a new MDB, then File/Get External Data/Link and point to your DSN. The test database contains no tables, so you won't actually be able to link anything, but you'll know whether everything is set up correctly. 6. If you're planning on moving existing Access data to MySQL, and said data uses ANPKs, then you can sidestep a potential issue by adding a timestamp column to every table prior to moving the data. If you don't do this, you may find that every time you insert a row, all its columns say "#deleted#". You won't see the actual data until you move off the new row and return. The timestamp column gets around this problem. 7. There are a number of MySQL GUI front ends that can easily import data from SQL Server or Access or other ODBC sources. dbTools is a good one. So is MySQLyog. Another good one is MySQLFront, but its author no longer supports it. Hth, Arthur -----Original Message----- From: dba-sqlserver-admin at databaseadvisors.com [mailto:dba-sqlserver-admin at databaseadvisors.com] On Behalf Of Jim Lawrence (AccessD) Sent: February 11, 2003 2:27 AM To: dba-sqlserver at databaseadvisors.com Subject: [dba-SQLServer]RE: Access connecting to MySQL Hi All: How difficult is it to connect MySQL to Access. Can it be done directly through a connection string like you would do with MSSQL and Oracle or do you have to use 'gasp' :-( an ODBC DNS. TIA Jim PS Access 2002 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com