Re: MSAccess --> MySQL - append query slows, then dies

2001-08-22 Thread Miguel Angel Solórzano
At 15:45 2001-08-22 -0400, Ide, James J Mr CMH/LGB wrote: Hi! My guess is that the append query is too much heavy for Access, then try to emigrate the data (if possible) using filter on the append query to make it with several steps. Other option is to use, other goods clients programs that you f

MSAccess --> MySQL - append query slows, then dies

2001-08-22 Thread Ide, James J Mr CMH/LGB
My setup: Dell PowerEdge 4200 with 512 mb ram, plenty of free disk space WinNT Server 4.0 with sp6 MS Access 97 MySQL 3.23.38-nt (installed binany from mysql-3_23_38-win.zip) MyODBC 2.50.38 (installed from myodbc-2_50_38-nt.zip) My objective: Copy data from two large MS Access 97 to MySQL tabl