Guest_imported
New member
- Jan 1, 1970
- 0
I am looking into converting an access 97 database to MySQL.
I have a lot of VBA code that opens many recordsets that are complex SQL statments. All the recordsets are processed at the same time.
Maybe i misunderstand something in MySQL, but it looks like I can only have one query(recordset) active at a time.
Do i have to make a separate connection for each recordset I want to process simultaneously? Or how can I simulate the multiple recordset processing i am used to doing.
I have a lot of VBA code that opens many recordsets that are complex SQL statments. All the recordsets are processed at the same time.
Maybe i misunderstand something in MySQL, but it looks like I can only have one query(recordset) active at a time.
Do i have to make a separate connection for each recordset I want to process simultaneously? Or how can I simulate the multiple recordset processing i am used to doing.
