-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Jonathan,
If you are going to be completely converting the Access db to MySQL, and just using Access as the frontend, you will need to download MyODBC: http://www.mysql.com/downloads/api-myodbc.html You can download either the stable or development release. There is also a FAQ that will answer your questions there about how to setup almost exactly what you are referring to. http://www.mysql.com/products/myodbc/faq_toc.html This FAQ is for the development release (3.51.03) but can also be used for the stable release (2.50.xx). I recently had to do the same thing with a Paradox database for a client, and have had relatively few issues following the documentation. After downloading and installing MyODBC you will be able to export the database directly to your Linux MySQL, however you will lose your table structures for the most part and will have to do some ALTER TABLE statements to put your keys back and the majority of your fields set to their proper type. HTH, Bryant Hester Juxtapose, inc. - -----Original Message----- From: Jonathan Coleman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 12:40 AM To: [EMAIL PROTECTED] Subject: MS Access and mySQL Hi. I have a situation where a church I am doing some volunteer work for has a MS Access (office 97) database running on NT. They are (woohoo) upgrading to a QUBE (linux box) for a server which has mySQL installed (and I can upgrade it etc..) My job therefore is to a) port MS Access data and queries to mySQL database b) use the MS Access forms to access the data and queries through ODBC. Is there anyone who can point me in the right direction, either to where the searchable discussion archives are, OR even better, someone who has gone through this before? Cheers Jon http://digital.yahoo.com.au - Yahoo! Digital How To - - Get the best out of your PC! - --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -----BEGIN PGP SIGNATURE----- Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com> iQA/AwUBPWzH6UlWu7/HFp4nEQJOGwCgr5af7wIi1AcbpP1rih/vABg/zb8An13w 4Tm8I6eugdNnVhLYZ+CcTYq2 =Z0ov -----END PGP SIGNATURE----- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
