G
Guest
I am using Office XP and am constantly crashing Excel. I have written VBA
code to use ADO to retrieve data from an Access database. The first time I
run the program, everything works fine. However, the second time I run it,
Excel crashes and asks to report the problem to MS. I can always restart
Excel, run the program with a new SQL statement, and get my answer. But
never twice in a row. Any ideas why ADO cannot run twice? (I am using ADO
2.7, if that helps.)
Thanks
code to use ADO to retrieve data from an Access database. The first time I
run the program, everything works fine. However, the second time I run it,
Excel crashes and asks to report the problem to MS. I can always restart
Excel, run the program with a new SQL statement, and get my answer. But
never twice in a row. Any ideas why ADO cannot run twice? (I am using ADO
2.7, if that helps.)
Thanks