> It gave me an error saying error in SQL syntaz at CREATE TABLE.. I think that's because your query does not look to me like valid MS Access SQL syntax.
> is the SQL sytnax exactly the same as 'normal' SQL syntax? Both Access and MySQL implement quite a lot of standard SQL syntax (if that's what you mean by "normal"), and both implement their own extensions. If you throw proprietary MySQL SQL syntax at Access it won't like it, and vice versa. You will need to read the Access documentation to find out what is allowed and how to spell it. Just as I had to read the MySQL documentation to find the different way I had to do things I was used to doing in Access. Tim Ward Brett Ward Limited - www.brettward.co.uk --------------------------------------------------------------------- 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