I am writing a conversion to convert approx 130 access databases to SQL. I have already created my SQL db, build the application for the front end and have converted a few of the databases on a "1 at a time" basis. To expedite the process, I have created a dynamic conversion. Items involved are a table listing all of the access dbs that need converted, 2 sql statements needed to pull the necessary data to convert and the location of the db. It works perfectly until I use the 2nd sql statement. I am getting an ODBC error: COUNT field incorrect. The baffling part is that I am not returning a count, and I am opening it in a recordset, so there is no mismatch of values & variables, or anything like that. I know that it isn't my connection because the first statement (to the same db using the same connection) works fine.
I cannot find ANY information anywhere within Microsofts "help" sites. Please, if anyone has any ideas, please share. This has been a 7 month project and is due to go live next Monday. Without data, I'm hosed!
Thank you so much!