This seems to be a very common question that appears very frequently on the group, in fact one I have asked in the past too.
Could I stick my head over the parapet and suggest a person or persons with experience of Access front ends and MySQL backend puts together an FAQ for this, or better still it's included in detail in the documentation? FWIW a very good utility for exporting tables and data is MyAccess (available from http://www.accessmysql.com/) it would appear that the latest version also supports synchronisation between the two databases. I have successfully used this to move an applications tables from Access to MySQL with very few problems except with new records causing problems in forms due to the way that Access queries the database and deals with the index information. HTH Alex --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.342 / Virus Database: 189 - Release Date: 14/03/2002 --------------------------------------------------------------------- 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
