I have developed an application that, using ADO, takes data from VFP6.0 tables and puts it into an Access2K database. It will also create new monthly tables in this Access database, when necessary. I developed it on a 233MHz PII and it runs perfectly fine. When I run it on a 933MHz PIII, it will create the tables, but will not insert the data. I have subsequently run the program on other computers with clock speeds inbetween these two, and it still runs fine. I only use one ADO connection (I hear that if you use two, it can affect read/write commands). Any suggestions or ideas?

Steve


Thanks everyone for your suggestions in this matter. I have come up with a solution to the problem, and it works perfectly fine each time. I guess to go into more detail about the process of my program, first it takes the data from my VFP tables and puts it into template tables in the Access database. Then my code takes the data in the template table and inserts it into an appropriate month table (ie. "5-2001-info"). If the monthly table does not exist, it is created. I have never had a problem putting the data into the template tables, just moving it from the template tables to the actual tables. I solved it by closing and reopening the ADODB connection between the update to the template table and the update to the actual table.