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

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