I am currently using MySQL version 3.23.39-max-nt, MS Access 2000 as my gui, and MyODBC 2.50.39-nt
I am able to run reports, queries and use the SQL pass through in access to retrieve data from the MySQL database through MyODBC. The problem is that I can not create a table in MySQL from Access in using the pass through to MyODBC. The SQL code works fine from the command line, but I am unable to get it to run through the pass-through in access. All of my other queries run fine, the only problem I have is with the create table and it gives me a generic error code. I have tested the DSN and it connects successfully. Any assistance would be helpful! TIA, Liz Craig --------------------------------------------------------------------- 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
