V
Vax
Guest
I have a several-statement SQL script that I need to run on a MS Access type database. The individual commands run fine by themselves in Access, but when I port them over verbatim to my SQL string I raise an exception every time. Theyre simple commands: one copies a single row of a duplicated record into a temporary table, one deletes the duplicated records from the original table, one copies the records in the temporary table back into the original table, and then one deletes the temporary table. Pretty straightforward.
I dont know about scripting support in Access, so I created a macro that runs each action query sequentially. This also works fine. Now, however, I run into a problem:
I cant run the individual queries in VB.NET for whatever reason (the lack of feedback is really ticking me off-- in VB6 it would tell me what it didnt like) and I cannot think of a way to execute the macro from my VB code.
Any ideas?
I dont know about scripting support in Access, so I created a macro that runs each action query sequentially. This also works fine. Now, however, I run into a problem:
I cant run the individual queries in VB.NET for whatever reason (the lack of feedback is really ticking me off-- in VB6 it would tell me what it didnt like) and I cannot think of a way to execute the macro from my VB code.
Any ideas?