Re:Speed Issue - Thanks

2002-07-01 Thread Simon Ashby
take on board the issue of bandwidth and using the dbSQLPassThru option. A fellow student put me onto MYSQL, which is proving to be the answer to my database problems, especially with such a supportive user group out there! Regards Simon Ashby

Speed issue

2002-07-01 Thread Simon Ashby
Hi I am trying to move an Access 2000 database into MYSQL 3.27.47nt running on a Win2K machine. MYODBC with the 3.51 drivers is also installed. MYSQL is running and readily responds to SQL queries using the DOS window at the mysql> prompt. However, when linking the MYSQL database with ADO and VB